936671 wrote:All the steps you need to implement before the upgrade are documented in the upgrade manual.
I remember Oracle Consulting has a script which it runs before any major upgrade( 11i to R12 for example) which lists all the objects and also the status whether it is upgrade safe/unsafe.
Can anyone give me the script.
I want to know that there may be some seeded codes and objects on which some customizations/modifications have been done ( say user hooks) for example.You have to revisit all the custom pages you have and test it after the upgrade, there is no way (through a script) to find out if your customizations were upgraded successfully or not.
Now I want to know that during upgrade if i run some script that will highlight that particular object