how to get to the count of missing objects
hi everyone,
I recently migrated database from Solaris platform and Linux platform. I noticed some objects are missing. I would like to write a query to get the missing objects counts...
let's say source database is S, target database is T, they are connected by a database link called (db_link_s)
how can I get to the following result? by running a query from the migrated database T side
-------------
owner object_type source_total Missing
------------------------------------------------------
schemaA table 200 9
schema B index 28 1
schema C function 5 0
Thanks!