Re: alter table a move...

From: Dario Bilic <dario_bilic_at_yahoo.com>
Date: Tue, 28 Aug 2001 10:31:03 +0200
Message-ID: <9mfks7$ehj4$1@as201.hinet.hr>

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