3 added relevant tags
source | link

I have Oracle 12c database and partitioned table. There is a old partition which has 68734MB which is 27% of total. 

I need to drop this partition. This is a production database and I does not have a downtime window for this. I

I want to know if I drop this partition, will the indexes of this table be unusable or rebuild ? What would be the best strategy to drop this partition with minimum impact on the live traffic  ?

I have Oracle 12c database and partitioned table. There is a old partition which has 68734MB which is 27% of total. I need to drop this partition. This is a production database and I does not have a downtime window for this. I want to know if I drop this partition, will the indexes of this table be unusable or rebuild ? What would be the best strategy to drop this partition with minimum impact on the live traffic  ?

I have Oracle 12c database and partitioned table. There is a old partition which has 68734MB which is 27% of total. 

I need to drop this partition. This is a production database and I does not have a downtime window for this.

I want to know if I drop this partition, will the indexes of this table be unusable or rebuild ? What would be the best strategy to drop this partition with minimum impact on the live traffic?

2 edited title
| link

Oracle 12c, Will dropping partition which has 27%25% of total data, rebuild the indexes?

1
source | link

Oracle 12c, Will dropping partition which has 27% of total data, rebuild the indexes?

I have Oracle 12c database and partitioned table. There is a old partition which has 68734MB which is 27% of total. I need to drop this partition. This is a production database and I does not have a downtime window for this. I want to know if I drop this partition, will the indexes of this table be unusable or rebuild ? What would be the best strategy to drop this partition with minimum impact on the live traffic ?