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… Continue Reading Enable DDL logging in Oracle 12c
- Posted on:
-
Author:
debasis maity
- Categories: security
- Tags: enable ddl logging
- 1 Comment on Enable DDL logging in Oracle 12c