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

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.