我是在用计划任务执行时发现的错误,具体报错如下:

ORA-31626: job does not exist

ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT_INT", line 600

ORA-39080: failed to create queues "KUPC$C_1_20140417021001" and "KUPC$S_1_20140417021001" for Data Pump

job

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPC$QUE_INT", line 1606

ORA-04031: unable to allocate 16777256 bytes of shared memory ("streams pool","unknown object","streams

pool","fixed allocation callback")


解决方式如下:

SQL> show parameter stream


NAME     TYPE VALUE

------------------------------------ ----------- ------------------------------

streams_pool_size     big integer 0

SQL> alter system set streams_pool_size = 100M scope=both;


System altered.


SQL> show parameter stream


NAME     TYPE VALUE

------------------------------------ ----------- ------------------------------

streams_pool_size     big integer 112M



因为没有配置流池导致了脚本无法执行。