CREATE TABLE SCES1INPUTS
(
CODREQUEST VARCHAR2(9 BYTE) NOT NULL,
LOBS1INPUT CLOB NOT NULL,
CODLAYOUT VARCHAR2(20 BYTE) NOT NULL,
DATINSERTION DATE DEFAULT SYSDATE NOT NULL,
CODINSERTIONUSER VARCHAR2(10 BYTE) NOT NULL,
CODINSERTIONFUNCTION VARCHAR2(5 BYTE) NOT NULL,
DATHISTORY DATE DEFAULT SYSDATE NOT NULL,
LOBS1INPUT_GZ BLOB
)
LOB (LOBS1INPUT) STORE AS LOB1_SCES1INPUTS
LOB (LOBS1INPUT_GZ) STORE AS LOB2_SCES1INPUTS
PARTITION BY RANGE ( DATINSERTION )
(
PARTITION "SCES1INPUTS_200508" VALUES LESS THAN (to_date('01092005','ddmmyyyy')) ,
PARTITION "SCES1INPUTS_200509" VALUES LESS THAN (to_date('01102005','ddmmyyyy')) ,
PARTITION "SCES1INPUTS_200510" VALUES LESS THAN (to_date('01112005','ddmmyyyy')) ,
PARTITION "SCES1INPUTS_200511" VALUES LESS THAN (to_date('01122005','ddmmyyyy')) ,
PARTITION "SCES1INPUTS_200512" VALUES LESS THAN (to_date('01012006','ddmmyyyy'))
)
/
SQL> SELECT table_name,column_name,segment_name,tablespace_name,index_name
2 from Dba_Lobs WHERE table_name='SCES1INPUTS';
TABLE_NAME COLUMN_NAME SEGMENT_NAME TABLESPACE_NAME INDEX_NAME
-------------------- -------------------- ------------------------------ -------------------- ----------------------------------------
SCES1INPUTS LOBS1INPUT LOB1_SCES1INPUTS USERS SYS_IL0000018502C00002$$
SCES1INPUTS LOBS1INPUT_GZ LOB2_SCES1INPUTS USERS SYS_IL0000018502C00008$$
SQL>
--move tablespace：
SQL> alter table SCES1INPUTS
2 move partition SCES1INPUTS_200508 tablespace USERS
3 lob (LOBS1INPUT) STORE as (tablespace tbs_ogg ENABLE STORAGE IN ROW CHUNK 8K PCTVERSION 0 NOCACHE )
4 lob (LOBS1INPUT_GZ) store as (tablespace tbs_ogg ENABLE STORAGE IN ROW CHUNK 8K PCTVERSION 0 NOCACHE );
Table altered.
SQL>
SQL> SELECT table_name,column_name,segment_name,tablespace_name,index_name
2 from Dba_Lobs WHERE table_name='SCES1INPUTS';
TABLE_NAME COLUMN_NAME SEGMENT_NAME TABLESPACE_NAME INDEX_NAME
-------------------- -------------------- ------------------------------ -------------------- ----------------------------------------
SCES1INPUTS LOBS1INPUT LOB1_SCES1INPUTS USERS SYS_IL0000018502C00002$$
SCES1INPUTS LOBS1INPUT_GZ LOB2_SCES1INPUTS USERS SYS_IL0000018502C00008$$
SQL>