Last DDL

[lgaorcl]

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!

[slimdave]

Commonly this would be a truncate, but could be a move, a partition-based DDL operation, erm .... some other things I suppose.

[Calvin_Qiu]

May check it LogMiner

[engiri]

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

[engiri]

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.