FW: How to use the Unused Column?

To: <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 19 Dec 2006 14:01:53 -0500

 
Forgot to post to board.

-- Mark D Powell --
Phone (313) 592-5148


-----Original Message-----
From: Powell, Mark D 
Sent: Tuesday, December 19, 2006 1:14 PM
To: 'Nagarajan.Subbiah@xxxxxxxx'
Subject: RE: How to use the Unused Column?


The last I knew Oracle does not support marking a column marked as
"unused" for reuse.  It does support dropping unused columns.

There was an article published on how to manipulate the dictionary to
get such a column back; however, this is totally unsupported and if
Oracle support detected that you have done this while you were working
with them on a problem they are likely to tell you to re-create your
entire database.


-- Mark D Powell --
Phone (313) 592-5148


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Tuesday, December 19, 2006 12:19 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: How to use the Unused Column?

Hi, 

One of our developer has asked this question.

"In our project we plan to drop some columns as we anticipate not to use
these columns. We do not want to drop the columns completely out of the
database and completely lose them, instead we would like to use the
unused columns feature in Oracle 10g. From the documentation I have read
so far, I could not find anything that says we can retrieve an unused
column and remove the unused mark against the column making it available
for use"

The development team would like to re-use the column if needed in the
future. Is there a way to do it or Once you set it unused you can't get
the column and data back?

We are at 10.2.0.2 on HP-UX 11.11.

Thanks
Raja.
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l

FW: How to use the Unused Column?

Other related posts: