Re: truncate or drop

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

MohanR_at_STARS-SMI.com 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 : samir.sarkar_at_nottingham.sema.slb.com
> samir.sarkar_at_sema.co.uk
>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: orantdba_at_netscape.net

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).