Hi,
Is it possible to not use the DBlink and still connect to another DB like connecting Database 1 from Database 2 see there is a discrepancy in the Database 2 table count using v$ , just i want to find out the tables in Database 2 which are having the mismatch table count records when we compared that with Database 1 , both these data bases 1 & 2 are supposed to have the same tables with count, if there is mismatch in the tables , it should throw a message to the user. If we can do through SQL or Procedure that will be fine, any examples of this will be highly appreciated.
Thanks in advance.