Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unrecoverable and nologging

582889Feb 22 2008 — edited Feb 22 2008
Hi is there any diffrence between unrecoverable and nologging.As far as I know both do not generate redo.

For instance:

1-)create table new_table unrecoverable as select * from old_table where ....;
2-)create table new_table nologging as select * from old_table where ....;



any diffrence?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2008
Added on Feb 22 2008
7 comments
4,555 views