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

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!