要点：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，如需转载请自行联系原作者
