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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Unused column names

RE: Unused column names

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 24 Sep 2004 16:02:28 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNKEBNCJAA.lex.de.haan@naturaljoin.nl>


Chaim,
why would you like to know them? those columns are lost forever anyway, except when using regular recovery techniques -- but then the names come back with the recovery :-)

Kind regards,
Lex.



visit http://www.naturaljoin.nl <http://www.naturaljoin.nl>

skype me <callto://lexdehaan>

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Katz.C_at_forces.gc.ca Sent: Friday, September 24, 2004 14:38
To: oracle-l_at_freelists.org
Subject: Unused column names

is it possible to identify the original names of columns that are no longer used (as in ALTER TABLE SET UNUSED COLUMN cname)?

thanks,
chaim
http://www.learntorah.net

http://www.ixora.com.au/ - For DBAs
http://directory.google.com/Top/Society/Religion_and_Spirituality/ - For All
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 24 2004 - 09:04:23 CDT

Original text of this message

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