Thursday, March 4, 2010

Export Datapump problem when using parallel paremeter in 10gR2 10.2.0.2 RAC database

When doing export datapump for Oracle database 10gR2 patch 2 RAC database, you should watch when using parallel parameter to export the data to more than one file at the same time.

when  running the following command it fails with an error, even it was running successfully before:
 
expdp system/pass@db10g schemas=test directory=TEST_DIR  
parallel=4 
dumpfile=test_%U.dmp logfile=test.log
 
 
This reported by oracle as a bug, and as a work around you limit the parallel parameter to 1 or patch your database to higher version such as 10.2.0.3 or 10.2.0.4. As this was solved in these patch numbers.

expdp system/pass@db10g schemas=test directory=TEST_DIR 
parallel=1 
dumpfile=test_%U.dmp logfile=test.log

No comments:

Post a Comment