Migrate records with INSERT INTO x SELECT FROM y statement and loop
|Added at||2017-01-02 16:01|
I need to migrate all the records from a tableA to a tableB. At the moment I'am simply using the following statement:
The problem is that if there is a high number of records the temporary tablespace might not have enough space to handle this statement. For this reason I would like to know if there is any way to still have this statement over a loop that commits, for example, 1000 records at the time.