big table transfer, best way?

[Quoted] [Quoted] I am wondering if there is a good way to transfer data from one [Quoted] [Quoted] schema to another, a slightly different one.

Currently we try to do:

insert into A_NEW (A_NEW_COL1, A_NEW_COL2) select A_OLD_COL1, A_OLD_COL2
from A_OLD;

This works fine for small tables. For big tables, however, there is a [Quoted] problem with the rollback segment size.

We also tried separating the command into two parts like

[Quoted] ... where rownum < 1000...

commit
....
... where rownum >= 1000 ...

etc

but it does not seem to work.

Thank you.
k& Received on Mon May 12 1997 - 00:00:00 CEST