Re: Rollback question

yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0202032117.2961c7d0_at_posting.google.com>...
> I almost want to say that it's an undocumented feature that nologging
> also means no undo. I only know discrete transactions do not generate
> undo although it generates redo. I finally find in Oracle8i Data
> Warehousing Guide, Chapter 18
> (http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76994/tuningpe.htm#53133)
> that says:
>
> When a table or index has NOLOGGING set, neither parallel nor serial
> direct-load INSERT operations generate undo or redo logs.
>
> In all other places of documentation that talks about nologging,
> there's no mention of no undo.
>
> Question for Tom: The create table statement does not have
> "nologging". No "alter table t nologging" follows. How can t be
> nologging, even though insert /*+ append */ is used?
>

I guess the "logging/nologging" option will be ignored when database in noarchivelog mode. But I can't find any documents about this.

Thanks,
Mike Received on Mon Feb 04 2002 - 09:54:33 CST