PL/SQL procedure
794455Oct 18 2010 — edited Oct 19 2010Have any idea about the following question, I need solution ASAP.
Schema: A_SCHEMA Schema: A_SCHEMA
SID: ORCL SID: ORCL
HOST: A HOST: B
The above database instances are identical on different servers.
Write a PLSQL routine that compares the Schema Objects in Schema A_SCHEMA on both instances. Also include a routine that performs comparison of data within the objects. Write the procedure with maintainability and reusability in mine.
Discuss any additional setup you need to perform the above task. Additionally discuss how you would synchronize the data between the environments if there were discrepancies.