Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to use the Unused Column?

How to use the Unused Column?

From: <oracle-l-bounce_at_freelists.org>
Date: Tue, 19 Dec 2006 12:19:00 -0500
Message-ID: <5598918403BB9F45ABC407657DDB7FF30AEDCB@exch2k3.aetvn.com>


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.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 19 2006 - 11:19:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US