When we insert many records into a table, it is faster to use hint /*+ append */. This way, Oracle will use direct path load to insert large amount of data that is much faster than conventional insert. As we see from the example below, when /*+ apeend */ hint is used, insert only takes 0.18 second vs 0.49 with conventional insert.
SQL> insert /*+ append */ into tbl_y select * from TBL_CLAIM_ALL@dl_apex2; 1031 rows created. Elapsed: 00:00:00.18 SQL> commit; Commit complete. Elapsed: 00:00:00.07 SQL> insert into tbl_y select * from TBL_CLAIM_ALL@dl_apex2; 1031 rows created. Elapsed: 00:00:00.49 SQL> commit;