OraFAQ Forum: Server Administration » XMLTYPE move to new tablespace

Home » RDBMS Server » Server Administration » XMLTYPE move to new tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

XMLTYPE move to new tablespace [message #63550]

Fri, 15 October 2004 03:45

Celia
Messages: 8
Registered: April 2003

Junior Member

I have an XMLTYPE column on a table. The column is stored as CLOB in a separate tablespace. Can anyone tell me the syntax to move the XMLTYPE column to a new tablespace. I have tried

ALTER TABLE X MOVE XMLType (column name) STORE AS CLOB (TABLESPACE newtablespacename CHUNK n NOCACHE LOGGING);

but this gives error
ORA-14133: ALTER TABLE MOVE cannot be combined with other operations

Report message to a moderator

Re: XMLTYPE move to new tablespace [message #63552 is a reply to message #63550]

Fri, 15 October 2004 04:16

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

Hi

you cannot move column alone you need to move table itself to new location

Regards

D.Dilip

Report message to a moderator

Re: XMLTYPE move to new tablespace [message #63553 is a reply to message #63550]

Fri, 15 October 2004 04:46

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

the syntax is 'a little ' different.
Please have a look here
http://www.orafaq.net/msgboard/server/messages/20908.htm

Report message to a moderator

Previous Topic:	the optimal method to replicate a production database in development database
Next Topic:	Alter Tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 23:11:08 CST 2025