Oracle-L: RE: Set unused column back to normal (solved)

From: Michael Wu <xwu_at_sempratrading.com>
Date: Wed, 20 Feb 2002 06:23:27 -0800
Message-ID: <F001.00414323.20020220062327@fatcity.com>

You either post the solution or do nothing. Your following message is meaningless just waster other people's time. Please show your courtesy before you post on a public list like this.

-----Original Message-----
Sent: Wednesday, February 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L

Solved

-----Original Message-----

Sent:	20 February 2002 17:20
To:	'Multiple recipients of list ORACLE-L'; 'LazyDBA mailing list'
Subject:	Set unused column back to normal

Hi all,

Any command setting back the unused column back to used ?

Negate this command please

ALTER TABLE mytable SET UNUSED mycol;

Sinardy

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sinard Xing
INET: sinardyxing_at_bcs-ach.com.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

This e-mail contains privileged attorney-client communications and/or confidential information, and is only for the use by the intended recipient. Receipt by an unintended recipient does not constitute a waiver of any applicable privilege."

Reading, disclosure, discussion, dissemination, distribution or copying of this information by anyone other than the intended recipient or his or her employees or agents is strictly prohibited. If you have received this communication in error, please immediately notify us and delete the original material from your computer."

Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or SoCalGas, the utilities owned by SET's parent company. SET is not regulated by the California Public Utilities Commission and you do not have to buy SET's products and services to continue to receive quality regulated service from the utilities."

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Michael Wu
INET: xwu_at_sempratrading.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------