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: 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.
as impdp â ???? / sysdba
Comments
Post a Comment