Oracle Database 11g added some support for Ddl Logging of RDMS DDL statements into the alert log.

In Oracle Database 12c, DDL Logging is by default OFF as default setting of parameter ENABLE_DDL_LOGGING to FALSE.

If you turned on, the RDBMS DDL logging is written to a new ADR file type that has the same format and basic behaviour as the alert log, but it only contains DDL statements and dates.

You can use below command to enable DDL Logging.

SQL> ALTER SYSTEM SET enable_ddl_logging= TRUE;

After enabling DDL Logging, Oracle Database records DDL Statement like below: –

CREATE TABLE employee…

CREATE INDEX employee_id_idx..

CREATE USER scott..

DROP USER scott..

Next, Disable DDL Logging.

SQL> ALTER SYSTEM SET enable_ddl_logging = FALSE;

After disabling DDL Logging, No DDL log file and No DDL recording in alert log.

DDL Log file log.xml is created in “$ADR_HOME/log/ddl” location.

The post Data Definition Language Logging in Oracle Database 12c appeared first on DBA Trainer.