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)
..
..
Saturday, April 17, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment