Merge last partition -- is it possible?

I have a table that's partitioned that really shouldn't be partitioned. I've merged the range partitions, two at a time into the higher ranging partition and now there is one partition left (ie ... values less than maxvalue).

Can this partition now be eliminated? -- ie, converted into a regular table while preserving the rows, or does the table have to be re-created?

I've gone through the syntax wire diagrams and can't find any syntax to "remove" the last partition and undo partitioning completely.

Thanks in advance .../Domenic. Received on Fri Oct 01 2004 - 09:27:45 CDT