I would like to know if it is possible to view the name of an unused column or it's data in an oracle table.
As I know you can query dba_unused_col_tabs to show you the numbers of unused columns in a table. But is it possible to reactivate the collumns set as unused and to have access again at it's data?
Any suggestion will be appreciated.
There is no Oracle command to undo "SET UNUSED COLUMN".
You have 3 choices:
1. An incomplete recovery prior to the time of the command.
2. Restore a cold backup of a timestamp prior to the time of the command.
3. Manually add a column (and insert the values).
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
Click Here to Expand Forum to Full Width