Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: exporting/importing tables
be very careful with this proposed solution. If the table is large (say millions of rows) this will run for a long time and often exhaust your rollback segment since you cannot commit until all done. I suggest you write a simple PL/SQL block to do the same that commits every 1000 records.
Bert Scalzo Received on Fri Jan 09 1998 - 00:00:00 CST