ORA-31623: A Job Is Not Attached To This Session Via The Specified Handle

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 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.

Hope it Helps!