Some of my tables show on toad that last DDL: for example 3/5/2005 2:26:19 AM.
The database has very limited access. I don't remember anybody did anything. What would be counted for this last DDL?
Thanks!
Printable View
Some of my tables show on toad that last DDL: for example 3/5/2005 2:26:19 AM.
The database has very limited access. I don't remember anybody did anything. What would be counted for this last DDL?
Thanks!
Commonly this would be a truncate, but could be a move, a partition-based DDL operation, erm .... some other things I suppose.
May check it LogMiner
Indexes on that table also cause the table to change the last ddl time, which you might missed to point.
SQL> select to_char(last_ddl_time,'hh24-mi-ss'),object_name from user_objects where object_name='N';
TO_CHAR( OBJECT_NAME
-------- ----------------------------------------
11-31-46 N
SQL> create index x_ind on N(no);
Index created.
SQL> select to_char(last_ddl_time,'hh24-mi-ss'),object_name from user_objects where object_name='N';
TO_CHAR( OBJECT_NAME
-------- ----------------------------------------
11-32-36 N
Cont..
SQL> drop index x_ind;
Index dropped.
SQL> select to_char(last_ddl_time,'hh24-mi-ss'),object_name from user_objects where object_name='N';
TO_CHAR( OBJECT_NAME
-------- ----------------------------------------
11-34-28 N
Rebuild index also plays this.