Monday, May 4, 2020

ORACLE 12C ENABLE DDL LOGGING

ORACLE 12C ENABLE DDL LOGGING

  • You can capture certain DDL statements  to a DDL log file by setting 
            ENABLE_DDL_LOGGING to TRUE.a

  • DDL log contains one log record for each DDL statement.
  • Two DDL log containing the same information:
      • XML DDL Log : named: log.xml
      • Text DDL: named ddl_sid.log


at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

student guide Dataguard: GLOBAL_DBNAME = <dbuniquename>_DGMGRL.example.com  Example: listener.ora on Primary Hosts Static listener ent...