Re: drop partition or make partition offline

From: John Thomas <>
Date: Mon, 15 Jun 2015 12:23:45 +0000
Message-ID: <>


Should be nothing to stop you dropping these partitions, and if all your indexes are local, nothing for you to do with indexes either.

However, if this is data you might want back, you might consider putting them in separate tablespaces and using transportable tablespace export before you offline then and back the tablespace and export metadata up. That way if the data is needed again it can be onlined in seconds with no need for a database restore.

Just depends what your requirements are.



On Mon, 15 Jun 2015 12:55 Mostafa Eletriby <> wrote:

> Hello folks,
> I have some questions regarding my case.
> I have database 11g R1 Prod at Unix HP - UX , database is in archive mode.
> there exist some tables partitioned with huge data and there are local
> indexes.
> My question is that I need to drop these partitions , Is it better to make
> them offline then drop them smoothly after checking the effect at data and
> data consistency or go ahead to drop after taking backup & check required
> steps for restoration.
> Also ,I need to know the steps to be performed after dropping those
> partitions regarding the local indexes & how to check them and to know all
> the effect in details.
> Thanks

Received on Mon Jun 15 2015 - 14:23:45 CEST

Original text of this message