title: oracle impdp - maximum open cursors exceeded
body: <p>I have exported a database schema from an oracle 10.2.0.5.0 database with <code>expdp</code>, logged in as the owner of the schema.</p>
  <p>Now I have tried to import the data on an Oracle 12.1.0.2.0 database <code>impdp</code>, logged in as sys with role <code>sysdba</code>.</p>
  <p>The expdp command:</p>
  <pre><code>expdp &quot;owner/password@hostname/servicename&quot; schemas=SCHEMA_NAME directory=EXPDIR dumpfile=SCHEMA_NAME.dmp logfile=SCHEMA_NAME.log 
  </code></pre>
  <p>The impdp command:</p>
  <pre><code>impdp &quot;sys/password@hostname/servicename as sysdba&quot; schemas=SCHEMA_NAME directory=EXPDIR dumpfile=SCHEMA_NAME.dmp logfile=SCHEMA_NAME.log 
  </code></pre>
  <p>The import gave me the error message:</p>
  <pre><code>Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
  Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
  ORA-39014: One or more workers have prematurely exited.
  ORA-39029: worker 1 with process name &quot;DW00&quot; prematurely terminated
  ORA-31671: Worker process DW00 had an unhandled exception.
  ORA-01000: maximum open cursors exceeded
  ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [INDEX:&quot;SCHEMA_NAME&quot;.&quot;UK$SOME$NAME&quot;] 
  CREATE UNIQUE INDEX &quot;SCHEMA_NAME&quot;.&quot;UK$SOME$NAME&quot; ON &quot;SCHEMA_NAME&quot;.&quot;TABLE_NAME&quot; (&quot;COLUMN_NAME&quot;) 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 &quot;TBLSPC&quot; PARALLEL 1 
  ORA-31625: Schema SYS is needed to import this object, but is unaccessible
  ORA-00604: error occurred at recursive SQL level 2
  ORA-01000: maximum open cursors exceeded
  ORA-06512: at &quot;SYS.KUPW$WORKER&quot;, line 9193
  ORA-06512: at &quot;SYS.KUPW$WORKER&quot;, line 22449
  ORA-31625: Schema SYS is needed to import this object, but is unaccessible
  ORA-00604: error occurred at recursive SQL level 2
  ORA-01000: maximum open cursors exceeded
  ORA-01000: maximum open cursors exceeded
  ORA-39014: One or more workers have prematurely exited.
  ORA-39029: worker 2 with process name &quot;DW00&quot; prematurely terminated
  ORA-31671: Worker process DW00 had an unhandled exception.
  ORA-01000: maximum open cursors exceeded
  ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [INDEX:&quot;SCHEMA_NAME&quot;.&quot;IDX$SOME$OTHER_NAME&quot;] 
  CREATE INDEX &quot;SCHEMA_NAME&quot;.&quot;IDX$SOME$OTHER_NAME&quot; ON &quot;SCHEMA_NAME&quot;.&quot;OTHER_TABLE_NAME&quot; (&quot;OTHER_COLUMN_NAME&quot;) 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 &quot;TBLSPC&quot; PARALLEL 1 
  ORA-31625: Schema SYS is needed to import this object, but is unaccessible
  ORA-00604: error occurred at recursive SQL level 2
  ORA-01000: maximum open cursors exceeded
  ORA-06512: at &quot;SYS.KUPW$WORKER&quot;, line 9193
  ORA-06512: at &quot;SYS.KUPW$WORKER&quot;, line 22449
  ORA-31625: Schema SYS is needed to import this object, but is unaccessible
  ORA-00604: error occurred at recursive SQL level 2
  ORA-01000: maximum open cursors exceeded
  ORA-01000: maximum open cursors exceeded
  Job &quot;SYS&quot;.&quot;SYS_IMPORT_SCHEMA_13&quot; stopped due to fatal error at Fri Dec 1 14:09:07 2017 elapsed 0 00:02:05
  </code></pre>
  <p>I have tried to increase the maximum number of open cursors, but it did not help.</p>
  <p>With the option EXCLUDE=INDEX, the import runs without errors, but I need them too.</p>
  <p>What can I try next?</p>