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

Home -> Community -> Usenet -> c.d.o.misc -> alter table a move tablespace xy

alter table a move tablespace xy

From: Martin Burkert <martin.burkert_at_A1plus.at>
Date: Tue, 28 Aug 2001 09:13:46 +0200
Message-ID: <9mfgeh$604$1@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 - 02:13:46 CDT












Original text of this message













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