开启该功能
SQL> alter system set enable_ddl_logging=true; System altered.
会记录以下操作的日志
CREATE ALTER DROP TRUNCATE TABLE DROP USER CREATE ALTER DROP PACKAGE|FUNCTION|VIEW|SYNOYM|SEQUENCE
测试
TRUNCATE表
SQL> truncate table test_a; Table truncated.
日志路径
$ORACLE_BASE/diag/rdbms/DBNAME/log/ddl
下面的XML文件和log目录下的日志文件
[root@rac2 log]# ll total 20 drwxr-xr-x 2 oracle oinstall 4096 Aug 30 23:12 ddl -rw-r----- 1 oracle oinstall 31 Aug 30 23:12 ddl_zxkj.log drwxr-xr-x 2 oracle oinstall 4096 Aug 17 01:41 debug drwxr-xr-x 2 oracle oinstall 4096 Aug 17 01:41 imdb drwxr-xr-x 2 oracle oinstall 4096 Aug 17 01:41 test [root@rac2 log]# pwd /u01/oracle/diag/rdbms/zxkj_s/zxkj/log [root@rac2 log]# cat ddl_zxkj.log diag_adl:truncate table test_a [root@rac2 log]# cd ddl [root@rac2 ddl]# ll total 4 -rw-r----- 1 oracle oinstall 254 Aug 30 23:12 log.xml
log.xml信息记录的更为具体
[root@rac2 ddl]# cat log.xml <msg time='2016-08-30T23:12:27.144+08:00' org_id='oracle' comp_id='rdbms' msg_id='kpdbLogDDL:18370:2946163730' type='UNKNOWN' group='diag_adl' level='16' host_id='rac2' host_addr='192.168.1.182' version='1'> <txt>truncate table test_a </txt> </msg>
版权声明:本文为博主原创文章,未经博主允许不得转载。