Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transaction without Rollback Segment?
Acutally I think that prevents redo information, not rollback information.
I don't think there is a way to prevent rollback info from being
genereated.
Connor McDonald wrote:
> CC wrote:
> >
> > hi all ,
> >
> > I 'd like to know if can I define a transaction without using any
> > Rollback Segment.
> > I want to execute many INSERT INTO... statements without using any
> > Rollback Segment. I think is something like SQL Loader's direct path.
> >
> > 10q
>
> alter table xxx nologging;
>
> insert /*+ APPEND */ into xxx
> select ... from other_table;
>
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Wed Nov 03 1999 - 13:36:11 CST