Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sub partition on table

3842403Mar 29 2019 — edited Mar 29 2019

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.

Comments

Post Details

Added on Mar 29 2019
#general-database-discussions
6 comments
195 views