Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Merge last partition -- is it possible?

Re: Merge last partition -- is it possible?

From: Domenic <domenicg_at_hotmail.com>
Date: 2 Oct 2004 08:05:55 -0700
Message-ID: <c7e08a19.0410020705.d9da082@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US