Hi All,
I have upgraded the 10g database to 11g and I need to perform the object count between source and target. I am thinking of creating a below table and using this table on target to compare the objects. I am still not able to come up the query, which I can use to compare difference.
SQL> create table rds_10_object_count as select OWNER , OBJECT_TYPE , status , count(*) "obj_count" from dba_objects
2 group by OWNER , OBJECT_TYPE , status ;