当使用nolog时,使用append 插入才不产生日志。
SQL>create table test as select * from dba_objects where 1=2;
SQL> alter table test nologging;
Table altered.
SQL> insert /*+append*/into test select * from dba_objects;
SQL> commit;
当使用nolog时,使用append 插入才不产生日志。
SQL>create table test as select * from dba_objects where 1=2;
SQL> alter table test nologging;
Table altered.
SQL> insert /*+append*/into test select * from dba_objects;
SQL> commit;