Records in DBA_OBJECTS and DBA_SOURCE do not match

From: GUPTA, DEEPENDER <DGUPTA_at_entergy.com>
Date: Thu, 6 Oct 2005 10:52:27 -0500
Message-ID: <E9270A7736A5914C94E0D74EB6A5136103C26C5F@tcbyexs02.ar.entergy.com>

I just queried my DBA_SOURCE and DBA_OBJECTS views and found out that record count in these two views are not matching for Triggers. I have not checked it for a while but last change we did was upgraded to Oracle 10G.. Did anybody have / face the same problem after 10G upgrade or any other changes in the database....Any ideas...suggestions.. Thanks,
Deepender

select distinct name from dba_source where owner like 'GIA' and type like 'TRIGGER'; NAME

---

GENERATION_PROFILE_BIUR
GROUP_ELECTION_BIUR select count(*) from dba_objects where owner like 'GIA' and object_type like 'TRIGGER';

  COUNT(*)

---

        44

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 06 2005 - 10:56:18 CDT