Code:SQL> select count(*) from test; COUNT(*) ---------- 5783 Elapsed: 00:00:00.01 SQL> create table test_1 nologging as select * from test; Table created. Elapsed: 00:00:00.05 SQL> insert /*+ APPEND */ into test_1 select * from test; 5783 rows created. Elapsed: 00:00:00.01




Reply With Quote