Database DataWarehousing (MOSC)

MOSC Banner

Partitioning

edited Mar 22, 2010 4:50AM in Database DataWarehousing (MOSC) 6 commentsAnswered
Can someone explain how partitioning works from a management point of view.  For example .. I have a table partitioned by date, 12 partitions, 1 partition per month.  I setup historical data so my partitions are 4/09, 5/09 ... 3/10.  When 4/10 comes along,  I need to drop partition 4/09 and add 4/10 and the similar for 5/10 and so on. Does oracle handle this automatically or does this need to be managed with a job ?

Thanks

Jeff

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