This content has been marked as final. Show 6 replies
you can try using Data Pump for export/import. Look for Oracle documentation for this
well, datapump is not recommended for EPPM. You should use imp/exp to export the database and use all your EPPM users (privuser, pubuser, admuser, etc)
Any idea why data pump is not recommended for EPPM? Can you please point me to any Oracle Doc on this or share your personal experience if there are issues with it?
I do not see any logical reason to use datapump here...although the only thing I have ever used it for is to migrate a database from one platform to another (Oracle to Microsoft).
Why would you not utilize Oracle's built-in imp/exp functionality to do this? Seems to me like this is a perfect use case.
I would say you can chose any one of them...its a matter of choice... Below are few of the Oracle docs and discussion. There are some advantages and some disadvantages of using one over the other
exp and expdp
I am still looking for doc that says data pump is not supported for EPPM or it cannot be used
Ahh, now I see. I was thinking of PPM's migrate.bat utility (as I have heard this referenced as pumping data). You are referring to impdp/expdp which is essentially the newer version of imp/exp. Certainly either could be used for refreshing/moving a schema but dp will likely produce faster results.
Another article referencing the difference between imp/impdp: http://www.dba-oracle.com/t_differences_imp_impdp_import_data_pump.htm