Last DDL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Last DDL

  1. #1
    Join Date
    Jun 2000
    Posts
    315

    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!

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Commonly this would be a truncate, but could be a move, a partition-based DDL operation, erm .... some other things I suppose.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    May check it LogMiner
    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

  4. #4
    Join Date
    Apr 2003
    Posts
    353
    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

  5. #5
    Join Date
    Apr 2003
    Posts
    353
    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
  •  



Click Here to Expand Forum to Full Width