Enable DDL logging in Oracle 12c
We need to enable DDL logging sometimes to track all DDL operations performed in database level. Step 1:-Please set ENABLE_DDL_LOGGING to TRUE Enter user-name: / as sysdba SQL> show parameter ENABLE_DDL_LOGGING; NAME TYPE VALUE ———————————— ———– —————————— enable_ddl_logging boolean FALSE SQL> alter system set ENABLE_DDL_LOGGING=TRUE; System altered. Step 2:-Identify where the xml files of DDL logging will be […]