Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing huge data
> ALTER SYSTEM ARCHIVE LOG STOP;
As Daniel pointed out, there is a difference between logging and
archiving. This stops the archiving, but not the logging. If your only
wish is to stop the excessive archiving then this will work. But the
side effect is that you won't be able to fully recover your database
from the previous backup. Not what I'd want to do. As I've already said,
the tool to use is NOLOGGING and a Direct path load in SQL*Loader. With
this option, you can still recover your database. You just won't be able
to recover the load operation that you performed. Big difference!!!
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Wed Sep 03 2003 - 10:59:06 CDT