Database DataWarehousing (MOSC)

MOSC Banner

interval partition names

edited Jan 14, 2010 12:50AM in Database DataWarehousing (MOSC) 2 commentsAnswered
 i'm not sure exactly where to post this question. i'm running oracle 11.1.0.6 and using interval partitioning which is nice but cumbersome. 
i find the system defined partition names a real drawback to efficient management of partitions.  it would be nice if i could put my own partition name in that i could then use in my partition manegement.  for example, if i'm partitioning by date i would like to have the haigh_value in the partition name. 
i find the 'partition for (to_date(xxxxxxxxxx)) syntax to limited.

so is there a way to have a trigger fire on the creation of a new partition?

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