How do I move lobindex/lobsegment from temp tablespace to another?
How do I move lobindex/lobsegment from temp tablespace to another?
It seems that these are the affected tables:
SQL> l
1 SELECT table_name,table_owner,tablespace_name
2 FROM user_indexes t
3* WHERE tablespace_name='TEMP'
SQL> /
TABLE_NAME TABLE_OWNER TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------
DEF$_AQCALL SYSTEM TEMP
DEF$_AQERROR SYSTEM TEMP
DEF$_LOB SYSTEM TEMP
DEF$_LOB SYSTEM TEMP
DEF$_LOB SYSTEM TEMP
DEF$_TEMP$LOB SYSTEM TEMP
DEF$_TEMP$LOB SYSTEM TEMP
DEF$_TEMP$LOB SYSTEM TEMP
REPCAT$_TEMPLATE_OBJECTS SYSTEM TEMP
REPCAT$_TEMPLATE_PARMS SYSTEM TEMP
REPCAT$_USER_PARM_VALUES SYSTEM TEMP
TABLE_NAME TABLE_OWNER TABLESPACE_NAME
It seems that these are the affected tables:
SQL> l
1 SELECT table_name,table_owner,tablespace_name
2 FROM user_indexes t
3* WHERE tablespace_name='TEMP'
SQL> /
TABLE_NAME TABLE_OWNER TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------
DEF$_AQCALL SYSTEM TEMP
DEF$_AQERROR SYSTEM TEMP
DEF$_LOB SYSTEM TEMP
DEF$_LOB SYSTEM TEMP
DEF$_LOB SYSTEM TEMP
DEF$_TEMP$LOB SYSTEM TEMP
DEF$_TEMP$LOB SYSTEM TEMP
DEF$_TEMP$LOB SYSTEM TEMP
REPCAT$_TEMPLATE_OBJECTS SYSTEM TEMP
REPCAT$_TEMPLATE_PARMS SYSTEM TEMP
REPCAT$_USER_PARM_VALUES SYSTEM TEMP
TABLE_NAME TABLE_OWNER TABLESPACE_NAME
0