syncronisation PPM Development DB Instance with PPM UAT DB Instance
I am trying to restore Oracle DB from Development machine to UAT machine, Upon completion of restoring the Development DB into UAT DB, I found out that, all the PL/SQL packages contain errors? I try to recompile the entire errors PL/SQL but still failed.
Is there something that need to be recompile in sequence during restoring? Please refer to attachment for the screen shot
Re: syncronisation PPM Development DB Instance with PPM UAT DB Instance
check out the SysAdmin Guide (Chapter 9 - Migrating Instances). There is a way how to clone databases. There is a script RecompileInvalid.sql somewhere in the PPM_HOME dir. Try this as ppm database user. If it didn't work try the way descript in chapter 9 of SysAdmin Guide. I have done a lot of database copies in this way. I has worked every time.