streams_pool_size for datapump 10.2.0.3 database
846231Mar 7 2012 — edited Mar 8 2012Hi All,
We have a Dev 10g database. We do usual data backup using generic exp command everyday.
We want to change the process using datapump since our new servers with 11g is now using datapump process.
When we first run the datapump most of the databases (we have like five 10g) got error related to "STREAMS_POOL_SIZE" needed to be set, which is not existing in the init.ora before. and setting this to a desired value (e.g. 1Mb) resolved the issue.
My question is why some 10g database, the expdp would run but the impdp would not? does this mean that expdp need a less memory than impdp?
Or can it be that at the time of running expdp there are less users?
Thanks a lot?
MissGuided