Get full ddl for oracle index

Question

I am using oracle 11g / 12c. I want to get ddl indexes in my database. For this, I used the query -

SELECT DBMS_METADATA.GET_DDL('INDEX','SYS_IL0000091971C00001$$','CCEEXPERTS') FROM dual

Here, "SYS_IL0000091971C00001 $$" is my name for the index, and "CCEEXPERTS" is my owner name.

From this I get ddl -

 CREATE UNIQUE INDEX "CCEEXPERTS"."SYS_IL0000091971C00001$$" ON "CCEEXPERTS"."DATABLOB" (

And my actual ddl is

CREATE UNIQUE INDEX "CCEEXPERTS"."SYS_IL0000091971C00001$$" ON "CCEEXPERTS"."DATABLOB" (
  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 "USERS" 
  PARALLEL (DEGREE 0 INSTANCES 0) ;

In the actual ddl after "CCEEXPERTS". "DATABLOB" (the next character of the string and from their ddl is narrowed.

How can I get the full ddl? Please help me...

Thanks in advance.

Answer 1

In SQLplus, install them before starting the procedure.

set long 100000
set longchucksize 100000