Hmmm, And I thought they were answering the question :-). I would actually do neither unless for some reason I HAD too. In all of the current versions of oracle I would rebuild rebuild this segment.
Best regards, John [EMAIL PROTECTED] wrote: >everybody is focussing on "how quick to destroy" without >considering what follow on work RBG has to do after the >bomb drops. > >It could be like taking over Kandahar, and leaving warring >tribes in control. You'd just be asking for trouble down >the road. > > > >-----Original Message----- >Sent: Monday, December 10, 2001 12:40 PM >To: Multiple recipients of list ORACLE-L > > >In my view a Truncate is always faster than a Drop. Also, the original >table structures of the table r preserved. > >Samir > >Samir Sarkar >Oracle DBA - Lennon Team >SchlumbergerSema >Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] >Phone : +44 (0) 115 - 95 76217 >EPABX : +44 (0) 115 - 957 6418 Ext. 76217 >Fax : +44 (0) 115 - 957 6018 > > >-----Original Message----- >Sent: 10 December 2001 16:40 >To: Multiple recipients of list ORACLE-L > > >Hi Everyone! > >I am trying to empty a database with some very large tables so I can import >it again. >Which is faster, truncating or dropping the tables? > >Thanks in advance, >Ruth > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).