RE: Procedure to DROP a 700 GB Table in 10gR2 ?
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <VIVEK_SHARMA@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 22 Jan 2007 11:54:14 -0700
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.
Other related posts:
