title: Customized Table DDL from dbms_metadata.get_ddl
body: <p>I want <code>DDL</code>s of Tables so that I can put it to the database server using <code>UTL</code> Package in Oracle.</p>
  
  <p>The problem is : When we </p>
  
  <pre><code>select dbms_metadata.get_ddl('TABLE','Table_name','Schema_Name') 
    from dual; 
  </code></pre>
  
  <p>I get an output which contains <code>CLOB</code> before <code>CREATE</code>. Like</p>
  
  <pre><code>"(CLOB) 
    CREATE TABLE "SCHEMA"."TABLE_NAME" 
     (TABLE_COLUMNS.....) SEGMENT CREATION IMMEDIATE 
    PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
   NOCOMPRESS LOGGING
    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 "INTF_DATA01" ;"
  </code></pre>
  
  <p>What I want is the above <code>DDL</code> without <code>CLOB</code> and without the parameters such as <code>SEGMENT CREATION</code>, <code>PCTFREE</code> ... ETC..</p>
  
  <p>Would be glad to get advise.</p>