Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Partition Tables and dropping/recreating indexes

RE: Partition Tables and dropping/recreating indexes

From: Diana Duncan <>
Date: Thu, 14 Dec 2000 14:49:52 -0500
Message-Id: <>


I think you should be able to do the following:

  1. export the data from the partition
  2. drop the partition (which will in turn drop the local index for that partition)
  3. recreate the partition (which will create the local index)
  4. reload the data

Have you considered moving the partition? Maybe that would clear up the fragmentation? I'm honestly not sure.


-----Original Message-----
From: lerobe - Lee Robertson [] Sent: Monday, December 11, 2000 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Partition Tables and dropping/recreating indexes


I have a partition of a table which has become fragmented. The plan is to extract the data, drop the index and reload the data then close it off. This will free up a bit of disk for us.  

My question is how feasible is this. Can the index partition be rebuilt purely for the partition we are unloading/reloading. I did an exp then an imp with indexfile to get out the sql and it says the index is LOCAL. From what I glean from the documentation, this means that it is possible to do what we originally planned.  

I would appreciate any hints or gotchas from anyone who has experience of this type of situation or indeed from anyone who has a good background in Oracle 8 (which I don't - YET !!).  


Lee Robertson

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.

Please see the official ORACLE-L FAQ:

Author: lerobe - Lee Robertson

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: (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 Thu Dec 14 2000 - 13:49:52 CST

Original text of this message