My Oracle Support Banner

IMPDP Using NETWORK_LINK Fails with ORA-1000 Maximum Open Cursors Exceeded (Doc ID 1325065.1)

Last updated on JULY 16, 2019

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms


Datapump Import IMPDP with NETWORK_LINK fails with

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [INDEX:"EFLOW_PARAMOUNT"."ZI097B_INV_STATUS_OUTBOUN_PK"]
ORA-01000: maximum open cursors exceeded
ORA-06512: at "SYS.DBMS_METADATA", line 5466
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8358

Changes

Increasing the number of cursors by parameter OPEN_CURSORS on the IMPDP target system does not help.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.