Re: Importing huge data

Jay wrote:

>I already have a insert statements.
>How can I use SQL*Loader ?
>
>Thanks.
>-Jay
>
>"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
>news:3F54DA25.9C8080F0_at_remove_spam.peasland.com...
>
>
>>Try seting the table to NOLOGGING and then using SQL*Loader and
>>performing a Direct path load. This will reduce your logging in the
>>online redo logs for this operation. Of course, you won't be able to
>>recover this operation, but that's your tradeoff.
>>
>>HTH,
>>Brian
>>
>>
>>Jay wrote:
>>
>>
>>>It's 8i.
>>>I have a script, text file contains insert statements.
>>>DB is in Linux.
>>>
>>>Thanks.
>>>-Jay
>>>
>>>"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
>>>news:1062523731.973181_at_yasure...
>>>
>>>
>>>>Jay wrote:
>>>>
>>>>
>>>>
>>>>>I am trying to import huge data into the tables.
>>>>>for the this session, I would like to turn some logging and rollback
>>>>>
>>>>>
>log
>
>
>>>for
>>>
>>>
>>>>>possible disk space problem.
>>>>>
>>>>>Could you tell me how can I do that?
>>>>>
>>>>>Thanks.
>>>>>-Jay
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>Can't be done nor is it necessary. What method are you using to load
>>>>
>>>>
>the
>
>
>>>>data? SQL*Loader? Insert statements? UTL_FILE? Import? What version
>>>>
>>>>
>and
>
>
>>>>edition of Oracle? On what platform?
>>>>
>>>>--
>>>>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)
>>>>
>>>>
>>>>
>>--
>>===================================================================
>>
>>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"
>>
>>
>
>
>
>

You can't. And you can't turn off logging and undo so don't bother trying. The best you can do is truncate the tables and use the APPEND hint. And while it will reduce ... it will not eliminate.

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