if you're using 8i, then option 1 is fine, if < 8.1 then option 2 is
your only choice.
joe>>> clchan_at_nie.edu.sg 08/29/01 10:21AM
>>>Hi Gurus,If the table is empty & U need to drop one
of the columns, do you 1) alter table tab_name drop column col_name or
2) drop & recreate tableI use option (1). Which is a better
choice ? TIARegds,New Bee-- Please see the
official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author: CHAN
Chor Ling Catherine (CSC) INET: clchan_at_nie.edu.sgFat City
Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California --
Public Internet access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Wed Aug 29 2001 - 09:32:18 CDT
