Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Records in DBA_OBJECTS and DBA_SOURCE do not match

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US