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

Home -> Community -> Usenet -> c.d.o.server -> alter table xx move tablespace yy varray ....

alter table xx move tablespace yy varray ....

From: Gerhard Hahn <gerhard.hahn_at_itellium.com>
Date: 7 Dec 2001 03:16:10 -0800
Message-ID: <2e3b56ec.0112070316.1daf525f@posting.google.com>


I have to move lobsegments to different Tablespaces which consists as a varray which is stored as lob.
I puzzled some ours to get the statement, without success. A description of the tables follwos below. The follwoing statement only moves the table itself not the lobsegment:

alter table qtabcms1 move tablespace qblob varray history store as lob history;

Please provide the correct statements.

QTABCMS1 and QTABQOT2 are the tables in question.

user_lobs:

PADO_TMP	         BILD	                SYS_LOB0000017449C00001$
PARTNERDOKUMENTE	"PADO_IMAGE"."CONTENT"	SYS_LOB0000008575C00004$
QTABCMS1	         HISTORY	        SYS_LOB0000036572C00026$$
QTABQOT2	"USER_DATA"."QUOTE_DATA_ARR"	SYS_LOB0000029977C00029$$
QTABRAW1	USER_DATA	                SYS_LOB0000023221C00025$$
QTABRAW2	USER_DATA	                SYS_LOB0000023211C00025$$
QTABRAW3	USER_DATA	                SYS_LOB0000028525C00025$$


Desription of the tables:

desc qtabcms1

 Name                                      Null?    Type
 ----------------------------------------- --------

----------------------------
Q_NAME VARCHAR2(30) MSGID NOT NULL RAW(16) CORRID VARCHAR2(128) PRIORITY NUMBER STATE NUMBER DELAY DATE EXPIRATION NUMBER TIME_MANAGER_INFO DATE LOCAL_ORDER_NO NUMBER CHAIN_NO NUMBER CSCN NUMBER DSCN NUMBER ENQ_TIME DATE ENQ_UID NUMBER ENQ_TID VARCHAR2(30) DEQ_TIME DATE DEQ_UID NUMBER DEQ_TID VARCHAR2(30) RETRY_COUNT NUMBER EXCEPTION_QSCHEMA VARCHAR2(30) EXCEPTION_QUEUE VARCHAR2(30) STEP_NO NUMBER RECIPIENT_KEY NUMBER DEQUEUE_MSGID RAW(16) REFCOUNT NUMBER HISTORY SYS.AQ$_HISTORY USER_DATA WPOE2CMS_T

History contains the varray

Description of SYS.AQ$_HISTORY

 desc SYS.AQ$_HISTORY
 SYS.AQ$_HISTORY VARRAY(1024) OF SYS.AQ$_DEQUEUE_HISTORY

 Name                                      Null?    Type
 ----------------------------------------- --------

----------------------------
CONSUMER VARCHAR2(30) TRANSACTION_ID VARCHAR2(22) DEQ_TIME DATE DEQ_USER NUMBER REMOTE_APPS VARCHAR2(4000) AGENT_NAMING NUMBER PROPAGATED_MSGID RAW(16) +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ desc qtabqot2 Name Null? Type ----------------------------------------- --------
----------------------------
Q_NAME VARCHAR2(30) MSGID NOT NULL RAW(16) CORRID VARCHAR2(128) PRIORITY NUMBER STATE NUMBER DELAY DATE EXPIRATION NUMBER TIME_MANAGER_INFO DATE LOCAL_ORDER_NO NUMBER CHAIN_NO NUMBER CSCN NUMBER DSCN NUMBER ENQ_TIME DATE ENQ_UID NUMBER ENQ_TID VARCHAR2(30) DEQ_TIME DATE DEQ_UID NUMBER DEQ_TID VARCHAR2(30) RETRY_COUNT NUMBER EXCEPTION_QSCHEMA VARCHAR2(30) EXCEPTION_QUEUE VARCHAR2(30) STEP_NO NUMBER RECIPIENT_KEY NUMBER DEQUEUE_MSGID RAW(16) USER_DATA PT_GETQUOTE_RSP

description of PT_GETQUOTE_RSP

desc PT_GETQUOTE_RSP

 Name                                      Null?    Type
 ----------------------------------------- --------

----------------------------
RIC_STATE NUMBER(2) SERVER_STATE NUMBER(2) NET_USE_STATE NUMBER(2) QUOTE_DATA_ARR QUOTE_DATA_ARR_T

Description of QUOTE_DATA_ARR_T

desc QUOTE_DATA_ARR_T
 QUOTE_DATA_ARR_T VARRAY(30) OF QUOTE_DATA_T

 Name                                      Null?    Type
 ----------------------------------------- --------

----------------------------
FID NUMBER(4) VALUE VARCHAR2(255)

regards

gerhard Received on Fri Dec 07 2001 - 05:16:10 CST

Original text of this message

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