title: Deferred Segment Creation feature not enabled (ORA-00439)
body: <p>I have <code>.sql</code> script file with DDL for more than 60 tables. I am trying to copy-paste the script into SQL Developer, connected to a database which is "Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production". </p>
  
  <p>Sample DDL Script:</p>
  
  <pre><code>CREATE TABLE UserName."Table_Name" 
     (    "Col1" NUMBER(*,0), 
      "Col2" VARCHAR2(50 BYTE), 
      "Col3" VARCHAR2(50 BYTE)
     ) SEGMENT CREATION DEFERRED 
    PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
    TABLESPACE "USERS" ;
  
  Error report -
  SQL Error: ORA-00439: feature not enabled: Deferred Segment Creation
  00439. 00000 -  "feature not enabled: %s"
  *Cause:    The specified feature is not enabled.
  *Action:   Do not attempt to use this feature.
  </code></pre>
  
  <p>If I remove <code>SEGMENT CREATION DEFERRED</code> in the DDL Script:</p>
  
  <pre><code>CREATE TABLE UserName."Table_Name" 
     (    "Col1" NUMBER(*,0), 
      "Col2" VARCHAR2(50 BYTE), 
      "Col3" VARCHAR2(50 BYTE)
     ) 
    PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
    TABLESPACE "USERS" ;
  </code></pre>
  
  <p>This works. But I can't manually remove that in  each and every table script.</p>
  
  <p>If I have <code>.dmp</code> dump file then the following syntax will also solve the issue; on the source instance:</p>
  
  <pre><code>EXPDP user/pwd dumpfile=somename.dmp directory=DATA_DUMP_DIR nologfile=Y version=10.2
  </code></pre>
  
  <p>and on the target instance</p>
  
  <pre><code>IMPDP user/pwd dumpfile=somename.dmp directory=DATA_DUMP_DIR nologfile=Y version=10.2
  </code></pre>
  
  <p>But I don't have a <code>.dmp</code> file, I only have a <code>.sql</code> file.</p>
  
  <p>Which is the best way of doing this?</p>