Re: Errors with Information_Schema in Create Target Results
Posted by: Vaughan Wickham
Date: October 29, 2021 06:50PM

Is this a good query to run against both servers to confirm that the databases are identical?

SELECT TABLE_NAME,SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'npchealth' GROUP BY TABLE_NAME;

Options: ReplyQuote


Subject
Written By
Posted
Re: Errors with Information_Schema in Create Target Results
October 29, 2021 06:50PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.