Re: exporting/importing tables

Bert Scalzo <bscalz01_at_7-11.com> wrote:
: 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.

Actually there is a commit=y option that does this for you within import. Received on Sat Jan 10 1998 - 00:00:00 CST