From JTESTA@longaberger.com Wed, 29 Aug 2001 07:32:18 -0700 From: "JOE TESTA" Date: Wed, 29 Aug 2001 07:32:18 -0700 Subject: Re: "Drop & Recreate table" or "alter table drop column". Message-ID: MIME-Version: 1.0 Content-Type: text/plain if you're using 8i, then option 1 is fine, if < 8.1 then option 2 is your only choice.   joe>>> clchan@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: http://www.orafaq.com-- Author: CHAN Chor Ling Catherine (CSC)  INET: clchan@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@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).