interval partition names
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?
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?
0