| drop sub partition on table [message #675429] |
Fri, 29 March 2019 01:58  |
 |
mss.prince@gmail.com
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
Thanks,
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
