ALTER SYSTEM ARCHIVE LOG STOP;
Does this not stop logging?
"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
news:3F54E1A6.6D713DE9_at_remove_spam.peasland.com...
> > I already have a insert statements.
>
> If I understand your requirements, then you wish to reduce the amount of
> logging that is created by your process. Is that correct? If so, then
> you cannot reduce logging if you are using simple INSERT statements.
> That is why I suggested the NOLOGGING on the table and using
> SQL*Loader's Direct path load. This can reduce your logging to the
> online redo logs.
>
> > How can I use SQL*Loader ?
>
> The Oracle Utilities Guide has tons of information, including samples
> uses of SQL*Loader. The doc can be found here:
>
> http://tahiti.oracle.com
>
> 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 Tue Sep 02 2003 - 13:56:29 CDT
