要点：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.
本文出自 “麦地坞” 博客，请务必保留此出处http://yunlongzheng.blog.51cto.com/788996/1532523