Re: Importing huge data

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"