Table Partition Modification =P

[Pixie22]

Ok so i have an application where the user must beable to add partitions, modify partitions and delete partitions of a table.

There are many potential problems here and i need to work out exactly where i need to merge as opposed to drop, split as opposed to add etc..

I was thinking of ADDing partitons that are flagged to be added, Modifying partitions that are flagged to be modded and after all that DELeting the partitions that are flagged to be deleted, in that specific order so that data isn't lost in the scenario of a user dropping a high partition with its data, and then adding a new high partition. The data would be lost ofcourse, but would not be lost if the new high partition was added first because the old high part would be merged as opposed to dropped in that case

would this be the easiest safest way of doing things? is there a faster way? Thanks

I am a little lost here ^_^

[slimdave]

I suppose that you could add a process to prevent partitions being dropped if they have any data in them, and require that a truncate be specifically issued by the user if data loss is required.

[PAVB]

A user adding/splitting and dropping partitions? scary!