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

If you are using flashback also, make sure you have enough space to grow
the flashback storage.

Ron

 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon
Sent: Monday, January 22, 2007 13:59 PM
To: VIVEK_SHARMA_at_infosys.com; oracle-l_at_freelists.org
Subject: 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.




-----------------------------------------
The information transmitted is intended solely for the individual
or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of or taking action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited. If you have received this email in error
please contact the sender and delete the material from any
computer.

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