Re: Merge last partition -- is it possible?

Domenic wrote:

> 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.

You should find examples of what you want at http://www.psoug.org Click on Morgan's Library
click on Partitions

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)