Re: Faster imports

Either the copy command in SQL*Plus or:

Write a procedure to

• alter the table to nologging, - insert the data with incremental commits,
• alter the table to logging

You can't alter a table to nologging in 7.x, but maybe there is another way to do the same thing.

The incremental commits didn't do much for me, but using nologging descreased a 3hr import to 30minutes.

-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!