RE: Procedure to DROP a 700 GB Table in 10gR2 ?

Oops, scratch that about the cascading deletes - forgot we're talking about dropping the table here, not deleting the rows - so that wouldn't apply. You would instead need to drop/disable any such constraints prior to dropping the table, or add the CASCADE CONSTRAINTS clause to your DROP statement.

From: Allen, Brandon
Sent: Monday, January 22, 2007 11:54 AM
To: 'VIVEK_SHARMA_at_infosys.com'; oracle-l_at_freelists.org Subject: RE: Procedure to DROP a 700 GB Table in 10gR2 ?

Not sure, but I'd think all 3 options would be pretty fast. Seems that #3 would be the easiest unless you really want/need to get rid of the tablespace too. Just one thing to keep in mind though since you're on 10g - unless you've disabled the recycle bin, with a regular DROP statement, it won't really be dropped, but rather will just be moved/renamed into the recycle bin, so you might want to consider adding the PURGE clause too. You also might want to check for constraints first, e.g. cascading deletes.  

Regards,
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

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