Re: ALTER TABLE SET UNUSED <column> clairified

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 17 Jan 2001 22:11:49 -0000
Message-ID: <979769712.29274.0.nnrp-08.9e984b29@news.demon.co.uk>

When a column is SET UNUSED, the name for the column is changed in the data dictionary, and a flag is set to identify the column as:'unused, data still present'.

In theory your database might survive if you found the column, put the name back, and reset the flag. The database would not be supported by Oracle though.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html

Received on Wed Jan 17 2001 - 16:11:49 CST