1、设置参数,动态参数
SQL> alter system set enable_ddl_logging=true;
System altered.
SQL> create table t (id int);
Table created.
SQL> alter session set container=pdb1;
Session altered.
SQL> drop table t;
Table dropped.
SQL>
2、查看ddl日志
$cd ddl
$ls
log.xml
$tail -f log.xml
level='16' host_id='roidb01' host_addr='fe80::9e8:140c:99e6:7ad9%enp0s3'>
truncate table t
msg_id='opiexe:4428:2946163730' type='UNKNOWN' group='diag_adl'
level='16' host_id='roidb01' host_addr='fe80::9e8:140c:99e6:7ad9%enp0s3'>
create table t (id int)
msg_id='kpdbLogDDL:19042:2946163730' type='UNKNOWN' group='diag_adl'
level='16' host_id='roidb01' host_addr='fe80::9e8:140c:99e6:7ad9%enp0s3'>
drop table t
^C
$pwd
/u01/app/oracle/diag/rdbms/cdb/cdb/log/ddl
---路径在这里
$