RE: Records in DBA_OBJECTS and DBA

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 6 Oct 2005 12:01:23 -0400
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A2490EB1@EXCHANGE.corp.perceptron.com>

Why don't you do:

select object_name from user_objects
where object_type = 'TRIGGER'
and object_name not in (
select name from user_source
where type = 'TRIGGER');

And find out, where the difference comes from?

Igor Neyman

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of GUPTA, DEEPENDER Sent: Thursday, October 06, 2005 11:52 AM To: Oracle-L
Subject: Records in DBA_OBJECTS and DBA_SOURCE do not match

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(*)

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 06 2005 - 11:05:17 CDT

RE: Records in DBA_OBJECTS and DBA_SOURCE do not match