DDL Logging
If you wish to enable DDL logging for your database by setting the parameter enable_ddl_logging to true , you must first license the Oracle Change Management Pack. If you set the enable_ddl_logging parameter to true, the instance will record the DDL changes in the log.xml file. If you don't set this parameter to true, Oracle won't record these changes to the log.xml or the alert log. SQL> sho parameter enable_ddl_logging NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ enable_ddl_logging boolean TRUE SQL> Log file location: /u01/app/oracle/diag/rdbms/oracmdb/ORACMDB/log/ddl