BLOB type compress colum table move to diffrant tablespace
CREATE TABLE CUS_SIG_BLOB_01
(
REF_NO NUMBER NOT NULL ENABLE,
CUS_IMAGE BLOB
) COMPRESS FOR ALL OPERATIONS
LOB(CUS_IMAGE) STORE AS SECUREFILE (
COMPRESS HIGH
CACHE
tablespace IMAGE_DAT_TS_01);
now data uploaded.
select index_name,table_name,tablespace_name from dba_indexes where owner=SH';
SQL> select index_name,table_name,tablespace_name from dba_indexes where owner='BUDDHIKA';
INDEX_NAME TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------
SYS_IL0000076095C00002$$ CUS_SIG_BLOB_01 IMAGE_DAT_TS_01
how to move this indx to diffrant tablespace?
thanks
ashwan