[20130814]12C DDL logging.txt
12c 能够很好的记录ddl语句,简单测试如下:
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
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博客 ” ,链接:http://blog.itpub.net/267265/viewspace-768634/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/267265/viewspace-768634/