DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002

    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.

  2. #2
    Join Date
    Jun 2001
    Helsinki. Finland
    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
    email: ocp_9i@yahoo.com

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.