ORACLE逻辑DATAGUARD创建表
要点: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.
网站标题:ORACLE逻辑DATAGUARD创建表
分享地址:http://scyanting.com/article/ghjgpe.html