Re: fastest method to copy data between databases

You said increasing the arraysize did not help.

May I suggest you verify that your tables are preallocated to be as large as they need to be. Extent allocation is relatively an expensive process in Oracle so eliminating them will help on larger tables.

Since importing and 'insert into' using a select clause require the use of rollback segments preallocating a large rollback segment and using 'set transaction use rollback segment x' may also benefit you on large table copies.

Hope this proves useful to someone.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise. Received on Thu Nov 14 1996 - 00:00:00 CST