I am using query similar to below to bulk insert data from one table into another table. The source table has over 150 million records. I disable all constraints on the target table & drop all indexes on target table before starting the bulk insert. This is taking more than 45 minutes to complete. How to speed up the transfer?
ALTER TABLE OWNER.TargetTable NOLOGGING;
INSERT /*+ APPEND PARALLEL(8) NOLOGGING */ INTO OWNER.TargetTable (Id, name…..)
SELECT /*+ PARALLEL(8) */ Id, name….. FROM OWNER.SourceTable;