Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Importing huge data

Re: Importing huge data

From: Jay <no_at_spam.com>
Date: Wed, 3 Sep 2003 14:11:09 -0400
Message-ID: <bj5an0$2fu2$1@msunews.cl.msu.edu>


Thank you guys.
I'm going with
NOLOGGING and a Direct path load in SQL*Loader

-Jay

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F560FCA.BEB646C4_at_remove_spam.peasland.com...
> > 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 - 13:11:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US