show name & data of unused columns

[aurelianda]

Hi,

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.

[julian]

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).