Re: Importing huge data

To use your existing code do the following:

Alter table target_table NOLOGGING;
 edit your insert statements to have this pattern:

    INSERT /* +append */ into target_table select etc...

The +append hint triggers a direct load...

"Jay" <no_at_spam.com> 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"
>
Received on Tue Sep 02 2003 - 14:17:01 CDT