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 to compare two objects ddl from different schema of different database

ReemaPuriDec 4 2018 — edited Dec 5 2018

how to compare two objects ddl  from different schema of different database

for example

table user_info

schema name :- schema2  and database service name sv2 and host name :- host2

create table user_info

(

id number,name varchar2(100));

schema name :- schema 1 and database service name sv1 and host name :- host1

create table user_info

(

id number);

I know it s possible by sql developer by functionality database diff ,but I want to do it by database link by script

can anybody give any idea about it .

This post has been answered by Sergei Krasnoslobodtsev on Dec 4 2018
Jump to Answer
Comments
Post Details
Added on Dec 4 2018
12 comments
1,120 views