ORA-31623: a job is not attached to this session via the specified handle

O erro ORA-31623 ocorre algumas vezes na hora de executar um expdp, isso ocorre devido o parametro streams_pool_size está com o valor 0

Vamos corrigir o problema.

[[email protected]~]$ sqlplus / as sysdba

SQL*Plus: Release Production on Sun May 12 17:11:42 2019

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter stream

------------------------------------ --------------------------------
streams_pool_size big integer
SQL> alter system set streams_pool_size=64M scope=both;
alter system set streams_pool_size=64M scope=both
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use

SQL> alter system set streams_pool_size=64M scope=memory;

System altered.



Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *