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

Thread: When did I add that column?

  1. #1
    I am trying to determine when I added a few column to some tables. I know the columns but not when I added them...

    Is there a way to easily determine the date the column was added? I don't see anything in DBA_TAB_COLUMNS.

    I do do daily exports, I hope not to have to compare the dmp files.

  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    may be you could check last_ddl in dba_objects, just an suggestion

  3. #3
    i think i got my own answer, but for anyone's interest...

    I uncompress my daily .dmp... I did the following (Unix only)

    strings day_15.dmp | grep "CREATE TABLE" > 15.txt
    strings day_22.dmp | grep "CREATE TABLE" > 22.txt

    diff 15.txt 22.txt

    that's it... I then see what was different.

    good luck.

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