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!

Table data count for schemas

User_19BPUApr 10 2020 — edited Apr 10 2020

Hi,

I have a DB1 (QA) & DB2 (Prod) , both contains Schemas – CATALOG (DB1) , CATALOG (DB2). Now I need to write a PL/SQL to compare the tables records count of these 2 schemas. Both these Schemas contains 270 tables, to find out both the schema tables record count are in sync we need to write a PL/SQL to compare the table count for these 2 different schemas running in 2 different Databases (DB1 & DB2).

Please let me know how to write a PL/SQL do the comparison for DB1 – CATALOG vs DB2 – CATALOG tables in these are 2 different Databases, so where we need to have the PL/SQL created in DB1 or in DB2 ? how we can compare the record of these 2 Databases tables? We need create a DBlink ? please provide any samples which will be of great help.

Thanks in advance.

This post has been answered by Frank Kulash on Apr 10 2020

Jump to Answer

Added on Apr 10 2020

9 comments

690 views