要点：alter database guard none;
创新互联从2013年创立，是专业互联网技术服务公司，拥有项目网站设计、成都做网站网站策划，项目实施与项目整合能力。我们以让每一个梦想脱颖而出为使命，1280元阳西做网站,已为上家服务,为阳西各地企业和个人服务,联系电话: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.
