Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing huge data
Jay wrote:
>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"
>>
>>
>
>
>
>
Logging and archiving logging are two entirely different things.
Logging is the original writing of transactions to the log files.
Archive logging is the process of copy log files to an archive destination when they are full.
You CAN NOT turn off logging. Go to http://asktom.oracle.com for thorough explanations of why if such is required.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Tue Sep 02 2003 - 18:33:33 CDT