要點：alter database guard none;?

-----------------------------------------------------

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.

本文轉自zylhsy 51CTO博客，原文鏈接：http://blog.51cto.com/yunlongzheng/1532523，如需轉載請自行聯系原作者

與50位技術專家面對面20年技術見證，附贈技術全景圖

總結

以上是生活随笔為你收集整理的ORACLE逻辑DATAGUARD创建表的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。