Hello All,
I am unable to run impdp in my database. Below is the error which I am getting:
Import: Release 11.2.0.4.0 - Production on Thu Nov 30 16:48:10 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
UDI-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1
I checked for the trace file and below is the error I am getting:
===============================
End 4031 Diagnostic Information
===============================
Incident 97193 created, dump file: /u01/app/oracle/diag/rdbms/********/*********/incident/incdir_97193/********_ora_382777_i97193.trc
ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","KUPC$S_1_20171129040506","streams pool","fixed allocation callback")
LibraryHandle: Address=0x889990368 Hash=54811a03 LockMode=X PinMode=X LoadLockMode=0 Status=VALD
ObjectName: Name=SYS.KUPC$S_1_20171129040506
FullHashValue=1bfce0ee1c96419e7dc04c2a54811a03 Namespace=QUEUE(10) Type=QUEUE(24) Identifier=5377873 OwnerIdn=0
Below is the parameter set in our environment:
sga_max_size big integer 33G
sga_target big integer 33G
streams_pool_size big integer 128M
Please help.