Register Login

How to Get Back Dropped Column of A Table?

Updated May 18, 2018

Hello Users,

I made a mistake and I bhave droped(student_address) a column from a table. Now I want to get back so can anyone from you guys tell me that how to get back that column? Please tell me as soon as possible as I have tried mostly everything that could be possible.

Thanks in Advance!


Comments

  • 27 Aug 2015 6:33 pm Nitesh Singh

    If flashback is enable then you can simply use it to recover your table column.

  • 27 Aug 2015 6:34 pm Abhijeet Mudgal

    You mean to say incomplete recovery there is not another way? I can not flashback on column level like flashback table (from recyclebin ). If droped table goes to recyclebin and updated(old) rows goes to undo what about droped column (where it goes)?

  • 27 Aug 2015 6:35 pm Nitesh Singh

    Yes incomplete recovery. well flashback will not work if you perform ddl in between. If you want to recover your column then use flashback which is use to recover your table consist of that column. And as per my knowledge ddl statements like dropping column does go anywhere as it's autocommited.

  • 27 Aug 2015 6:36 pm Chandan Singh Parihar

    Hey Abhijit when did you drop your table column. If it is very recent then just check with your db you can get it back by using logminer.

  • 27 Aug 2015 6:37 pm Romil Tripathi

    You may use the timestamp query or use flash back query or recyclebin query.

  • 27 Aug 2015 6:37 pm Jyoti Pandey

    If your db is in flashback mode then use flashback query. You'll easily can get it.

  • 27 Aug 2015 6:39 pm Sugandh

    If your db is not in flash backmode then its better to use point in time recovery. If your db is not in flash backmode then its better to use point in time recovery.

  • 27 Aug 2015 6:39 pm Sushma

    Just use this below given:
    Flash back table tablename;
    For table flash back
    ***nooo need to enble flashback**
    Its work above


×