Skip to Main Content

Oracle Database Discussions

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!

compare parameters between 2 databases via database link

JayDee41Dec 12 2019 — edited Dec 12 2019

Hi Team,

Could anyone help to check the code to compare parameters between 2 databases via database link.

I have so far;

select a.name,a.value from v$parameter a

where a.value not in

(select b.value from v$parameter@pwtgolink b)

and a.name = b.name;

ERROR at line 4:

ORA-00904: "B"."NAME": invalid identifier

Thanks for any help.

jd

Comments
Post Details
Added on Dec 12 2019
4 comments
1,213 views