SQL Language (MOSC)

MOSC Banner

how to get to the count of missing objects

in SQL Language (MOSC) 6 commentsAnswered ✓

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!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center