Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

syncronisation PPM Development DB Instance with PPM UAT DB Instance

Highlighted
Saw Teong Soon
Acclaimed Contributor

syncronisation PPM Development DB Instance with PPM UAT DB Instance

Hi Folks,

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
1 REPLY

Re: syncronisation PPM Development DB Instance with PPM UAT DB Instance

Hi,

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.

Regards
Volker
//Add this to "OnDomLoad" event