Re: alter table a move...

On Tue, 28 Aug 2001, Dario Bilic wrote:

> Hi there,
>
> Error message "Keyword partition expected" showed up because
> ALTER TABLE statement has only MOVE PARTITION clause,
> not the MOVE clause:
>
> The following statement moves partition depot2 to tablespace ts094:
> ALTER TABLE parts
> MOVE PARTITION depot2 TABLESPACE ts094 NOLOGGING;
>
> I'm not quite sure what are you trying to do?

I would like to write old Tables with all constraints.... to a new Tablespace.
The tables are not partitioned, but sql plus says, that the keyword "partition" is expectet.
However I tried the expected Keyword "partition => the new error-message is, that the table is not partitioned. :-|

Is it possible, Oracle 8.0.5 doesnt support this feature?

>
> Dario
>
> "Martin Burkert" <martin.burkert_at_A1plus.at> wrote in message
> news:9mfg1n$5ne$1_at_fstgss02.tu-graz.ac.at...
> > Hi!
> >
> > I've got a problem with this Statment:
> >
> > alter table a move tablespace xy;
> >
> > I would like to change the default tablespace usr from table a to a new
> > tablespace xy. I created the tablespace xy with Oracle Storage Manager,
> > table a is not a partitioned.
> >
> > But the Error-message is: "keyword partition expectet" (this is my German
> to
> > Englisch-Translation) ;-)
> >
> > What can i do?
> >
> >
>
>
>
Received on Tue Aug 28 2001 - 04:15:35 CDT