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

Thread: Last_ddl_time

  1. 10-10-2006, 12:46 AM #1
    xyz2000
    xyz2000 is offline Member
    Join Date
    Jan 2001
    Posts
    191

    Last_ddl_time

    there are two databases. One is the backup of another database about 1 month ago.

    In this one month, I found out some tables got modified by checking dba_objects last_ddl_time.

    But when I use DBMS_METADATA.GET_DDL package to retrive ddl for those tables, I find no diff on those tables. I also checked dba_constraints and there is no difference on those tables also. Any idea what kind ddl used on those tables? To me, those tables are same.
    Reply With Quote Reply With Quote
  2. 10-10-2006, 01:04 AM #2
    yxez
    yxez is offline Advisor
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    what kind of backup did u take?
    Behind The Success And Failure Of A Man Is A Woman
    Reply With Quote Reply With Quote
  3. 10-10-2006, 04:19 AM #3
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no, unless you have auditing turned on you wont be able to find out
    Reply With Quote Reply With Quote
  4. 10-10-2006, 12:39 PM #4
    xyz2000
    xyz2000 is offline Member
    Join Date
    Jan 2001
    Posts
    191
    rman cold backup and restore to create a copy database. It should be schema freeze but somehow someone still using DDL on those tables.
    Reply With Quote Reply With Quote
  5. 10-10-2006, 12:46 PM #5
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    as i saidm you cant find out unless you have auditing turned on
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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