Database Administration (MOSC)

MOSC Banner

How to change the name of an existing lob segment

edited Aug 18, 2017 10:06AM in Database Administration (MOSC) 4 commentsAnswered

In the following example, I need to rename SYS_LOB0000055604C00002$$ to a new name such as LOB_MAX2. How can I do it ?

select table_name,column_name,owner,tablespace_name,segment_name,index_name,PCTVERSION,RETENTION_TYPE,RETENTION_value,SECUREFILE from dba_lobs where table_name='TEST_SEC_MAX2';

TABLE_NAME           COLUMN_NAME     OWNER      TABLESPACE_NAME SEGMENT_NAME              INDEX_NAME                PCTVERSION RETENTI RETENTION_VALUE SEC

-------------------- --------------- ---------- --------------- ------------------------- ------------------------- ---------- ------- --------------- ---

TEST_SEC_MAX2        MAX2COL2        SCOTT      TS_INFO_DAT_01  SYS_LOB0000055604C00002$$  SYS_IL0005257682C00002$$             DEFAULT                 YES  

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