Current location - Loan Platform Complete Network - Big data management - Millions of data volume inserted into another table in batches, how to achieve it
Millions of data volume inserted into another table in batches, how to achieve it
Massive data volume commit may cause system paralysis, so it is not recommended. If necessary, you can export the insert statement when the batch commit (submit). Methods are as follows: 1, log in plsql, enter the export table 2, select the table to be exported, and then the following position according to the need to write each time how many rows to submit