Re: How to use the Unused Column?

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: Nagarajan.Subbiah@xxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 19 Dec 2006 18:25:51 +0000

You cannot get it back. Set Unused defers the drop until later. You
can of course add columns later. This sort of discussion suggests to
me poor design and/or spec

On 12/19/06, oracle-l-bounce@xxxxxxxxxxxxx
<oracle-l-bounce@xxxxxxxxxxxxx> wrote:

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 on HP-UX 11.11.


Niall Litchfield
Oracle DBA

Other related posts: