You can use Oracle GoldenGate to:

• Perform a standalone batch load to populate database tables for migration or other purposes.

• Load data into database tables as part of an initial synchronization run in preparation for change synchronization with Oracle GoldenGate.

If you are working with an Oracle to Oracle replication, there are optimized methods because the instantiation has the highest precision based on the SCN value. In this case, the HANDLECOLLISIONS parameter isn't required.

See HANDLECOLLISIONS | NOHANDLECOLLISIONS.

For non-Oracle environments, traditional methods are used for the initial load.