Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ENABLE_DDL_LOGGING

Property Description
Parameter type Boolean
Default value false
Modifiable ALTER SESSION, ALTER SYSTEM
Range of values true | false
Basic No

ENABLE_DDL_LOGGING enables or disables the writing of a subset of DDL statements to the alert log.

When ENABLE_DDL_LOGGING is set to true, the following DDL statements are written to the alert log:

Note:

The DDL statement written to the alert log may be truncated. You can use DDL triggers to view the entire DDL statement. See Oracle Database PL/SQL Language Reference for more information about DDL triggers.