show name & data of unused columns
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: show name & data of unused columns

  1. #1
    Join Date
    Apr 2002
    Posts
    2
    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.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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