DB Wiki

By enabling an initialisation parameter you can now log all DDL commands

ALTER SYSTEM SET enable_ddl_logging=true;

The logs can be found in the following locations

$ADR_BASE/diag/rdbms/{DB-name}/{SID}/log/ddl_{SID}.log
$ADR_BASE/diag/rdbms/{DB-name}/{SID}/log/ddl/log.xml