Skip to Main Content

SQL & PL/SQL

Announcement

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!

how does the where clause work here?

User_68DIPDec 29 2020

SELECT ename, e.deptno, dname, loc
FROM emp e, dept d
WHERE e.deptno > d.deptno;

This post has been answered by Billy Verreynne on Dec 29 2020
Jump to Answer

Comments

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 

1 - 1

Post Details

Added on Dec 29 2020
4 comments
60 views