Re: Oracle/3rd party tool/utility to copy data from one table to the other

Just drop the indices, do the insert, and recreate the indices.

Also, turning off archiving while performing the insert will help.

There might be some tools available to do this, but I just wrote a 50 line PL/SQL block which does it all.

-greg

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!