ENABLE DDL_LOGGING

SQL> alter system set enable_ddl_logging=TRUE;

System altered.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@localhost ddl]$ pwd
/u01/app/oracle/diag/rdbms/orcl/orcl/log/ddl

[oracle@localhost log]$ ls
ddl  debug  test
[oracle@localhost log]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Fri May 8 21:42:36 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> connect hr/hr;
Connected.
SQL> create table prueba5 as (select * from hr.employees);

Table created.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@localhost log]$ pwd
/u01/app/oracle/diag/rdbms/orcl/orcl/log

[oracle@localhost log]$ ls
ddl  ddl_orcl.log  debug  test

[oracle@localhost log]$ cat ddl_orcl.log
Fri May 08 21:43:01 2020
diag_adl:create table prueba5 as (select * from hr.employees)
[oracle@localhost log]$