Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    46

    Unanswered: To find the deleted columns in a table

    Hi,

    I had a table in which a particular column was exisiting and suddenlty I found that the column is misssing.

    How do I come to know as to when the column was deleted from that table.

    Thanks

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    If you do not have auditing enabled, this is nearly impossible to be sure... With auditing, I think you could but I don't know how.

    I think LOGMINER could help you but I've never used it. Somebody else here may tell you more about it.

    You can query ALL_OBJECTS or USER_OBJECTS and get the LAST_DDL_TIME column. If the DELETE was the last DDL operation on the table, then you're lucky and this is it, else it will be of no help .

    Another solution would be to have a look at your latest exports and see the last one having this column...

    HTH & Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •