How to enable ddl logging in Oracle Container database 19c ?
Solution:
At CDB:
SQL> ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;
-- ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=BOTH; -- Turn off
Any PDB:
create table tbl_a (num number);
alter table tbl_a add num2 number;
Check ddl logging with new log file:
$DUMP_LOCATION/log/ddl_dbname.log and
$DUMP_LOCATION/log/ddl/log.xml
ddl_dbname.log or log.xml:
2021-01-28T13:46:41.640037-05:00
diag_adl:create table tbl_a (num number)
2021-01-28T13:50:20.725803-05:00
diag_adl:alter table tbl_a add num2 number
No comments:
Post a Comment