Home » RDBMS Server » Server Administration » drop sub partition on table
drop sub partition on table [message #675429] Fri, 29 March 2019 01:58 Go to next message
Messages: 1
Registered: March 2019
Junior Member
Hi Gurus,

we are using oracle 12c. I have 300 + tables and will be going to create sub partition on monthly bases.. we need to drop data on every month because table should have only last 1 years data.

i am going to create package with below steps. could you please help me here by provide best your valuable inputs.

here is my flow.

1. will check is there any job is running.. if running .. will check every 10 mints until all jobs completed..
2. will disable all jobs
3. drop all sub partition 's
4. re build all indexes on all tables
5. enable jobs


Re: drop sub partition on table [message #675430 is a reply to message #675429] Fri, 29 March 2019 02:05 Go to previous message
John Watson
Messages: 8914
Registered: January 2010
Location: Global Village
Senior Member
Cross posted,
Next Topic: Need advice to Migrate 11g to 12c using datapump
Goto Forum:

Current Time: Tue Feb 20 19:24:41 CST 2024