RE: Records in DBA_OBJECTS and DBA_SOURCE do not match
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <DGUPTA@xxxxxxxxxxx>, "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 Oct 2005 12:01:23 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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(*)
----------
44
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
