title: Get complete ddl for index in oracle
body: <p>I am using oracle 11g/12c. I want to get ddl of indexes in my database. For this I used the query - </p>
  
  <pre><code>SELECT DBMS_METADATA.GET_DDL('INDEX','SYS_IL0000091971C00001$$','CCEEXPERTS') FROM dual
  </code></pre>
  
  <p>Here 'SYS_IL0000091971C00001$$' is my index name and 'CCEEXPERTS' is my owner name.</p>
  
  <p>From this I get the ddl - </p>
  
  <pre><code> CREATE UNIQUE INDEX "CCEEXPERTS"."SYS_IL0000091971C00001$$" ON "CCEEXPERTS"."DATABLOB" (
  </code></pre>
  
  <p>And my actual ddl is -</p>
  
  <pre><code>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) ;
  </code></pre>
  
  <p>In actual ddl after "CCEEXPERTS"."DATABLOB" ( , next line character and from their the ddl is truncted.</p>
  
  <p>How can I get the complete ddl? Please help me...</p>
  
  <p>Thanks in advance. </p>