Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to move the tablespace CLOB colums

448733Sep 17 2008 — edited Sep 17 2008

Dear all,

I need to move the tablespace of CLOB column for follwing table definition:

CREATE TABLE LOBDATA
( ID NUMBER NOT NULL ENABLE,
MSG_RS SYS.XMLTYPE ,
TABLESPACE DATATBS
XMLTYPE COLUMN "MSG_RS" STORE AS CLOB "MSG_RS_TT"(
TABLESPACE "DATALOB" DISABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
NOCACHE LOGGING

Oracle version is 10g release 2.

Please puts your ideas on this

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2008

Added on Sep 17 2008

#general-database-discussions

11 comments

3,547 views