Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Merge last partition -- is it possible?
Thanks Daniel!!
Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1096677298.638884_at_yasure>...
> 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
Received on Sat Oct 02 2004 - 10:05:55 CDT