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.

• Dc.

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