Re: Importing huge data

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 - 13:27:09 CDT