Database Administration (MOSC)

MOSC Banner

How do I move lobindex/lobsegment from temp tablespace to another?

edited Dec 16, 2009 12:35AM in Database Administration (MOSC) 7 commentsAnswered
 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

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