Database Software

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 Issue

755639Jul 8 2012 — edited Jul 8 2012

Hi all,

Recently i have Imported one legacy database into 11g, Import was successful and i have checked all the OBJECT Counts, it matched with old DB.

but there are some packages are not found for a particular super user 'APPS'.

when i execute this below command i can find all the objects counts with the user/schema wise, this count matched with old database count,

select owner,object_type,count() from dba_objects group by owner,object_type order by owner;*

but while using this command with the table ALL_OBJECTS, for the particular schema lot of packages are missing,,

select owner,object_type,count() from all_objects where owner='APPS' group by owner,object_type order by owner,object_type;*

Kindly some one explain me what is the diffrent between this two Quearys and more over why the packages are missing,,

i have created the Database manually, is this a reason for package missing ???

Regards

Paja