Database DataWarehousing (MOSC)

MOSC Banner

dropping a partition from an interval partitioned table

edited Apr 21, 2011 3:26AM in Database DataWarehousing (MOSC) 6 commentsAnswered
Hello everyone.

I am building a procedure to drop a single partition from an interval partitioned table based on a date (oracle version - 11.1.0.7). The goal - is to let other users to drop a partition from a table in another schema as part of a purge process. We have been doing similar things for a while, but this is the first time I use an interval partitioned table (most of other tables are partitioned by range). The partitions are weekly. So we will have partitions with high values , say April 7, April 14, April 21, April 28. May 5 etc.

Here is my concern. Lets say someone runs the procedure to drop partition containing  April 5th  via

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center