Database Administration (MOSC)

MOSC Banner

BLOB type compress colum table move to diffrant tablespace

edited Jan 20, 2011 3:40PM in Database Administration (MOSC) 6 commentsAnswered ✓
hi export, I have created table with BLOB and table cmpression.

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center