Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> alter table xx move tablespace yy varray ....
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