How does dropping a partition affect the rest of the table?

From: <Cherie_Machler_at_gelco.com>
Date: Fri, 13 Apr 2001 12:27:29 -0700
Message-ID: <F001.002E9668.20010413121634@fatcity.com>

I've looked through the on-line documentation on dropping partitions but I have not seen the following question specifically addressed:

How does dropping a date-range partition affect the rest of the table/partitions? I read that if I drop a partition with a global partitioned index that the entire global index will need to be rebuilt but that's about all I've seen about the affect on the other partitions.

Can I drop an unneeded partition on the fly? What is the effect on performance of the rest of the table? Does anything need to be brought offline before I drop the desired partition?

Thanks in advance to all you knowledgable partitioners.

Cherie Machler
Gelco Information Network

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Cherie_Machler_at_gelco.com

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). Received on Fri Apr 13 2001 - 14:27:29 CDT