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






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: 7933
Registered: January 2010
Location: Global Village
Senior Member
Cross posted,
https://community.oracle.com/thread/4209861
Previous Topic: CREATE PLUGGABLE DATABASE fails
Next Topic: ORA-28000: the account is locked - how to investigate it ?
Goto Forum:
  


Current Time: Sat Jun 15 20:31:43 CDT 2019