ORA-31623: A Job Is Not Attached To This Session Via The Specified Handle
ANKUSH THAVALI
08 Dec, 2023
0 Comments
18 Secs Read
ORA-31623: A Job Is Not Attached To This Session Via The Specified Handle
While taking export or import , you may face below issue.
Solution :
Increase the stream_pool_size to 64 M.
SQL> show parameter stream
NAME TYPE VALUE
———————————— ———– ——————————
streams_pool_size big integer 0
SQL> alter system set streams_pool_size=64M scope=both;
System altered.
Else configure automatic memory management(AMM) by setting memory_target parameter.