[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

ITPub博客

[20130814]12C DDL logging.txt

最新文章