[askdba] LOGGING Feature in database

  • From: Rajesh Puneyani <rajpuneyani@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Thu, 11 Nov 2004 10:54:36 -0500

Hi guys,

This is just to confirm - 

If I have FORCE LOGGING enabled at the database level then every DDL
command I execute (without specifying LOGGING/NOLOGGING option) would
be executed using LOGGING option.

IF I specifically say NOLOGGING in ALTER TABLE ...MODIFY (for example)
then NOLOGGING has the priority.

Pls confirm or clarify.

Other related posts: