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 previous message
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,






 
Read Message
Read Message
Previous Topic: CREATE PLUGGABLE DATABASE fails
Next Topic: Need advice to Migrate 11g to 12c using datapump
Goto Forum:
  


Current Time: Thu Apr 18 21:33:58 CDT 2024