I have table with 20 columns (mostly number datatype) and 15 billion records. I would like to make a copy of this table.
In my current script, I'm using FORALL to insert 5000 records.
This script is loading at a pace of 250,000 records/second taking about 18 hours for a complete load.
Is there a more efficient way to address this through SQL script?
I'm working on :
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Windows 11 Enterprise