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

Thread: table dropped

  1. #1
    Join Date
    Apr 2004
    Location
    chennai
    Posts
    9

    table dropped

    which dict do i view to find out the TIMESTAMP A TABLE HAS BEEN DROPPED
    Thanks
    Vijay

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You need auditing on to do that -- when a table has been dropped it is no longer referenced in the data dictionary.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by slimdave
    You need auditing on to do that -- when a table has been dropped it is no longer referenced in the data dictionary.
    would not logminer do it as well? completly not fun for sure but if he really needs to know..
    I'm stmontgo and I approve of this message

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