-
Last DDL
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.
-
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|