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

From: <Cherie_Machler_at_gelco.com>
Date: Tue, 17 Apr 2001 08:25:03 -0700
Message-ID: <F001.002EAC2D.20010417070639@fatcity.com>

Stephane,

Thanks for your reply.

Cherie

                                                                                       
                              
                    paquette stephane                                                  
                              
                    <stephane_paquette@        To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>   
                    yahoo.com>                 cc:                                     
                              
                    Sent by:                   Subject:     Re: How does dropping a 
partition affect the rest of the 
                    root_at_fatcity.com           table?                                  
                              
                                                                                       
                              
                                                                                       
                              
                    04/17/01 08:40 AM                                                  
                              
                    Please respond to                                                  
                              
                    ORACLE-L                                                           
                              
                                                                                       
                              
                                                                                       
                              

If your indexes are local then no problem . If the indexes are global you 'll have to rebuild them .

• Cherie_Machler_at_gelco.com a écrit : >
  > 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).
  

  ---

Stéphane Paquette
DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com

---

Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: stephane_paquette_at_yahoo.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).




--
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 Tue Apr 17 2001 - 10:25:03 CDT