../E40402-16.epub /> ../E40402-16.mobi />

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:

  • ALTER/CREATE/DROP/TRUNCATE CLUSTER

  • ALTER/CREATE/DROP FUNCTION

  • ALTER/CREATE/DROP INDEX

  • ALTER/CREATE/DROP OUTLINE

  • ALTER/CREATE/DROP PACKAGE

  • ALTER/CREATE/DROP PACKAGE BODY

  • ALTER/CREATE/DROP PROCEDURE

  • ALTER/CREATE/DROP PROFILE

  • ALTER/CREATE/DROP SEQUENCE

  • CREATE/DROP SYNONYM

  • ALTER/CREATE/DROP/RENAME/TRUNCATE TABLE

  • ALTER/CREATE/DROP TRIGGER

  • ALTER/CREATE/DROP TYPE

  • ALTER/CREATE/DROP TYPE BODY

  • DROP USER

  • ALTER/CREATE/DROP VIEW

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.