Re: Importing huge data

I used
Alter table target_table NOLOGGING
and then inserted a record and
I was able to rollback.
If NOLOGGING stop logging into redo file. how can I rollback?

Should I just use autocommit for my session?

Thanks.
-Jay

"Turkbear" <john.greco_at_dot.state.mn.us> wrote in message news:61r9lvk7di2kh8ccdcm3hm63t7n77ro9kq_at_4ax.com...
>
> 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:53:50 CDT