Database DataWarehousing (MOSC)

MOSC Banner

Splitting an Interval Partitioned Table

edited Jan 14, 2010 12:49AM in Database DataWarehousing (MOSC) 2 commentsAnswered
Is there any "easy" way to split an existing interval partitioned table?  I have an interval partitioned table that is partitioned by day (NUMTODSINTERVAL(1,'DAY')) that I want to make interval partitioned by hour (NUMTODSINTERVAL(1,'HOUR')).  It has existing data in it and as such existing partitions.  Is there a simple way to split this existing table into hourly partitions or do I have to re-create the table as an hourly interval partitioned table and re-load all of the data?
Thanks,
Greg

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