[20130814]12C DDL logging.txt
12c 能够很好的记录ddl语句,简单测试如下:
SQL> @ver
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 0
SQL> show parameter enable_ddl_logging
NAME TYPE VALUE
------------------- -------- --------
enable_ddl_logging boolean FALSE
SQL> alter session set enable_ddl_logging = true;
System altered.
SQL> create table t1 ( a int );
Table created.
SQL> drop table t purge;
Table dropped.
查看目录下D:\app\oracle\diag\rdbms\test\test\log,存在如下文件ddl_test.log:
存在记录如下:
Wed Aug 14 20:54:45 2013
diag_adl:create table t1 ( a int )
diag_adl:truncate table t1
diag_adl:drop table t1 purge