We help IT Professionals succeed at work.

Oracle - recover the columns marked as unused

luchuanc
luchuanc asked
on
Hi,
Is there a way to recover the columns that were marked as unused?

thanks,

Luchuan
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
The only way I know of is to recover the table from a backup or flashback then recreate the column:

http://www.experts-exchange.com/Database/Oracle/Q_24960287.html
Top Expert 2011
Commented:
- its not possible. the UNUSED feature is to "hide" the column temporary from user and drop that column later when it is more convenient (when database usage not busy).

- if you have a backup of that table, then what you can do is
1- to do a restore
2- OR drop that column and recreate that column.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
lol, OP, this is getting to be a habit...
Top Expert 2011

Commented:
lol! however you are faster!
i always get timed-out when posting. this new layout slow in my region :(

Author

Commented:
Thanks a lot for your help!

Luchuan

Explore More ContentExplore courses, solutions, and other research materials related to this topic.