Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

object count across database.

940856Jul 30 2012 — edited Jul 31 2012
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 ;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2012
Added on Jul 30 2012
8 comments
2,011 views