Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alter table a move...
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?
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 - 03:31:03 CDT