Saturday, April 17, 2010

DDL Logging

ENABLE_DDL_LOGGING
With 11g you can now log ddl into your alert.log (which I thought was cool)


SQL> alter system set enable_ddl_logging=true;
SQL>
SQL> create table x (y number, z timestamp);

following is in trace/alert_MYDB1.log
..
..
Sat Apr 11 12:20:48 2010
create table x (y number, z timestamp)
..
..

No comments: