I would like if someone can help me out of the following problem:
I am working with a database with hundreds of huge tables. Now, i have to put the entire set of records in another rbales (just making a copy, bu not the same as: Create TABLE as select * from another table)
I want to read a table of 1.000.000(1 million records)in the next way:
1) read the firts 10.000 records in the table,
2) write them away in another table
3) remove the already read 10.000 records
4) read next 10.000
and so on until all records have been read.
I hope someone can help me.
I tried it out with 'CURSOR' but it did not work proper.
Help me please