ENABLE_DDL_LOGGING In Oracle 12c

This ENABLE_DDL_LOGGING parameter has been introduced in oracle 12c.

Enable the parameter:

SQL> show parameter enable_ddl_logging
NAME TYPE VALUE
———————————— ———– ——————————
enable_ddl_logging boolean FALSE

SQL> alter system set enable_ddl_logging=true;
System altered.

SQL> show parameter enable_ddl_logging
NAME TYPE VALUE
———————————— ———– ——————————
enable_ddl_logging boolean TRUE

Do some DDL operations:

SQL> create user testuser identified by testuser;
User created.

SQL> create table testuser.table1 (n number);
Table created.

SQL> drop user testuser cascade;
User dropped.

Check the log:

cd /u02/app/oracle/diag/rdbms/cdborcl/cdborcl/log/ddl

more log.xml