Oracle datapump import into new 10.2.0.5 database -


We are currently migrating to a new brand / Oracle DB to upgrade our memory To populate, we have decided to use the functionality of the Oracle data pump and create a flat export file that is completed without any error.

However, when it is imported into the new DB, then it is returned the following errors:

The exact import as soon as possible Update this question with syntax: Update:

  as impdp â ???? / sysdba    

Div cl AD = "text">

Here is the main error message:

ORA-04030: When trying to allocate 4194328 bytes out of the process memory (Pga heap, buf_kgcstate) < / P>

This date Base is not enough memory to complete the import. It is not related to the amount of RAM on the box, but the amount of RAM is specially allocated to the Oracle. It is controlled by the memory_target parameter in Oracle 11g.

Which version of Oracle is running? Here is a known bug about the import of data in Version 11.2:

It seems that you are killing this problem. To carry out working data and to gather again after import. Try adding

EXCLUDE = Statistics

to your parameter file, and it probably will work.

Comments

Popular posts from this blog

c - Mpirun hangs when mpi send and recieve is put in a loop -

python - Apply coupon to a customer's subscription based on non-stripe related actions on the site -

java - Unable to get JDBC connection in Spring application to MySQL -