Oracle Logic Dataguard Creating tables

IMPORTANT: Alter DATABASE guard none;

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

DBA User Build Table

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

Sql> CREATE TABLE Liang.testa as select * from Tab;

Table created.

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

DBA User under

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

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.

This article is from the "Wheat Dock" blog, please make sure to keep this source http://yunlongzheng.blog.51cto.com/788996/1532523