select table_name,logging from user_tables where table_name=UPPER('mx_mta_ip_log')
ALTER table MX_MTA_LOG NOLOGGING
SQL>
SQL>
SQL> create table big_table as select * from all_objects where 1=0;
Table created.
SQL>
SQL> set autotrace on statistics;
SQL>
SQL> insert into big_table select * from all_objects where rownum < 50;
SQL> insert /*+ APPEND */ into big_table select * from all_objects where rownum < 50;
SQL> commit;
Commit complete.
SQL> alter table big_table nologging;
Table altered.
SQL> insert into big_table
2 select * from all_objects where rownum < 50;
49 rows created.
SQL> insert /*+ APPEND */ into big_table
2 select * from all_objects where rownum < 50;
49 rows created.
SQL> commit;
Commit complete.
SQL>
SQL> drop table big_table;
Table dropped.
SQL>
SQL>
阅读(784) | 评论(0) | 转发(0) |