enable_ddl_logging - cheeyoung/sqlplus-public GitHub Wiki

enable_ddl_logging=true

...
  +400  Thu Apr 13 02:32:09 2017
  +401  CREATE TABLE table11
  +402  (       col01 CHAR(2) NOT NULL
  +403  ,       col02 CHAR(2) NOT NULL
  +404  --,     hsc01310 CHAR(2) DEFAULT 'BB' NOT NULL
  +405  ,       hsc01310 CHAR(2) DEFAULT 'BB'
  +406  )
  +407  alter table table11 modify hsc01310 varchar2(2)
...

2.119 ENABLE_DDL_LOGGING

Property	Description
Modifiable	ALTER SESSION, ALTER SYSTEM

The DDL log contains one log record for each DDL statement issued by the database. The DDL log is included in IPS incident packages.

There are two DDL logs that contain the same information. One is an XML file, and the other is a text file. The DDL log is stored in the log/ddl subdirectory of the ADR home.