Please let me know the best practice to refresh Production Database with Test Database.
We using Primavera EPPM 8.1.No we need to refresh the production database with test.
Please help me in getting sime scripts or procedure to export all the schemas of test and import them to production.
Basically I am looking if we need to have some steps to be followed for p6 extended schema(pxrptuser) and other stuff.
Thanks & Best Regards
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
http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm#i1008963 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