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!

alter database force logging and alter table nologging

user128148Aug 26 2010 — edited Aug 26 2010
Hi,

Which statements takes precedence, "alter database force logging" or "alter table nologging"?

If I set "alter database force logging" to a database and then later some one issue 'alter table nologging'. Would the table be in nologging even if the database was set in force logging mode? Thank you in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2010
Added on Aug 26 2010
3 comments
4,089 views