Home » SQL & PL/SQL » SQL & PL/SQL » how to change unused to used columns
how to change unused to used columns [message #209069] Wed, 13 December 2006 03:35 Go to next message
Messages: 65
Registered: November 2006
Location: Mumbai

Hi All,

Is ther any possibility to change unused column to used one

Re: how to change unused to used columns [message #209071 is a reply to message #209069] Wed, 13 December 2006 03:41 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you've set a column to unused by specifying SET UNUSED on the drop column command, then I'm afraid that the column and it's contents are gone, and there's no way to get it back other than to finishe dropping it (with ALTER TABLE....DROP UNUSED COLUMNS) and then add a new column with the same name.
Previous Topic: Hw to enable entry in USER_AUDIT_SESSION
Next Topic: back ground tables
Goto Forum:

Current Time: Tue Aug 22 23:34:23 CDT 2017

Total time taken to generate the page: 0.16576 seconds