ORACLE logical DATAGUARD create tables

Main point: alter database guard none

Create tables for DBA users

SQL > create table liang.testa as select * from tab

Table created.

Under DBA users

SQL > conn liang/liang

Connected.

SQL > select * from tab

TNAME TABTYPE CLUSTERID

TESTA TABLE

SQL > select count (*) from tab

COUNT (*)

-

one

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.