For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
SELECT ename, e.deptno, dname, loc FROM emp e, dept d WHERE e.deptno > d.deptno;
I would definitely go with option #3. It is the easiest and the one with the least down time. I would suggest that you use AutoUpgrade to do the upgrade instead of the manual upgrade. It is easier and it does support having source Oracle Home and target Oracle Home on two different servers. Take a look at the Database Upgrade Quick Start Guide which shows how to get started with the tool. In your case you would execute "analyze" and "fixups" mode on the source system and wait for the changes to be applied on the standby. Then you break the connection and you can eventually do the upgrade using the "upgrade" mode. In your configuration file instead of specifying a "target_home" you should specify "target_version" instead.
Regards,
Daniel