SQL & PL/SQL

Hi,

I developed 1 application where in i Ran SQL tunning advisor to tune some queries and it created many indexes.

So now i have to rename those indexes(LOB) to something like table_name_column name so i need to get metadata to check on which columns these lob indexes are cerated

But when i ran get ddl statement i don't get column names on which these lob indexes are created.

Example:

SQL> select dbms_metadata.get_ddl('INDEX','SYS_IL0000113826C00055$$','XXI') from dual;

DBMS_METADATA.GET_DDL('INDEX','SYS_IL0000113826C00055$$','XXCEMLI')

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

CREATE UNIQUE INDEX "XXI"."SYS_IL0000113826C00055$$" ON "XX"."tbs1_MV" (

  PCTFREE 10 INITRANS 2 MAXTRANS 255

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

  TABLESPACE "XXI_D"

  PARALLEL (DEGREE 0 INSTANCES 0)

DBMS_METADATA.GET_DDL('INDEX','SYS_IL0000113826C00012$$','XXCEMLI')

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

  CREATE UNIQUE INDEX "XXI"."SYS_IL0000113826C00012$$" ON "XXCEMLI"."tbs1_MV" (

  PCTFREE 10 INITRANS 2 MAXTRANS 255

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

  TABLESPACE "XXI_D"

  PARALLEL (DEGREE 0 INSTANCES 0)