[试验] NOLOGGING table在streams环境中能否顺利复制

源：strm1
目标：strm2
DBAUSR schema级别的复制环境
-- strm1
17:14:51 strmadmin@STRM1> create table dbausr.test_nolog
17:19:21   2  ( id number(6),
17:19:44   3    name varchar(20)
17:20:08   4  ) nologging;

Table created.

-- strm2
17:21:08 strmadmin@STRM2> select TABLE_NAME,LOGGING from dba_tables where wner='DBAUSR';

TABLE_NAME                     LOG
------------------------------ ---
BONUS                          YES
DEPT                           YES
DUMMY                          YES
EMP                            YES
SALGRADE                       YES
TEST_NOLOG                     NO

-- strm1
17:23:50 strmadmin@STRM1> insert /*+ append */ into dbausr.test_nolog values (1,'aaa');
17:27:40 strmadmin@STRM1> commit;
--strm2
17:28:06 strmadmin@STRM2> select * from dbausr.test_nolog;
        ID NAME
---------- --------------------
         1 aaa
-- strm1
17:40:15 strmadmin@STRM1> delete from dbausr.test_nolog where id=1;

1 row deleted.

17:40:21 strmadmin@STRM1> commit;

Commit complete.
-- strm2
17:40:27 strmadmin@STRM2> /

no rows selected

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/317003/viewspace-594891/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/317003/viewspace-594891/