要點(diǎn):alter database guard none;
創(chuàng)新互聯(lián)從2013年創(chuàng)立,是專業(yè)互聯(lián)網(wǎng)技術(shù)服務(wù)公司,擁有項(xiàng)目網(wǎng)站設(shè)計(jì)、成都做網(wǎng)站網(wǎng)站策劃,項(xiàng)目實(shí)施與項(xiàng)目整合能力。我們以讓每一個(gè)夢想脫穎而出為使命,1280元陽西做網(wǎng)站,已為上家服務(wù),為陽西各地企業(yè)和個(gè)人服務(wù),聯(lián)系電話:13518219792
-----------------------------------------------------
DBA用戶下建表
-----------------------------------------------------
SQL> create table liang.testa as select * from tab;
Table created.
-----------------------------------------------------
DBA用戶下
-----------------------------------------------------
SQL> conn liang/liang
Connected.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
TESTA TABLE
SQL> select count(*) from tab;
COUNT(*)
----------
1
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
TESTA TABLE
SQL> select count(*) from testa;
COUNT(*)
----------
3693
SQL> delete testa;
delete testa
*
ERROR at line 1:
ORA-16224: Database Guard is enabled
SQL> conn / as sysdba
Connected.
SQL> alter database guard standby;
Database altered.
SQL> conn liang/liang;
Connected.
SQL> delete testa;
delete testa
*
ERROR at line 1:
ORA-16224: Database Guard is enabled
SQL> alter database guard none;
Database altered.
SQL> delete testa;
3693 rows deleted.
SQL> commit;
Commit complete.
SQL> create table testb as select * from tab;
Table created.
網(wǎng)頁標(biāo)題:ORACLE邏輯DATAGUARD創(chuàng)建表
當(dāng)前URL:http://www.muchs.cn/article34/ghjgpe.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供標(biāo)簽優(yōu)化、外貿(mào)建站、響應(yīng)式網(wǎng)站、品牌網(wǎng)站建設(shè)、軟件開發(fā)、全網(wǎng)營銷推廣
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)