How to change the name of an existing lob segment
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