Do I need to increase streams_pool_size when I do data pump full export?
Posted on 2008-06-23
When I did data pump full export, I got the following error message.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 111
ORA-06512: at "SYS.KUPC$QUE_INT", line 444
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2500
ORA-06512: at "SYS.DBMS_DATAPUMP", line 1509
ORA-06512: at line 1
I got the suggstion from metalink to increase streams_pool_size. But I got the following error when increase it.
SQL> alter system set streams_pool_size=100M ;
alter system set streams_pool_size=100M
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool
How to fix it?