Re: DBA_SOURCE vs DBA

From: Michael J. Moore <hicamel_x_the_spam_at_attbi.com>
Date: Wed, 18 Sep 2002 20:54:57 GMT
Message-ID: <BK5i9.139496$Jo.40127@rwcrnsc53>

FYI, there are 89 distinct trigger names in my DBA_TRIGGERS table.

  1 SELECT trigger_name
  2 FROM DBA_triggers
  3 INTERSECT
  4 SELECT name
  5* FROM DBA_source

yeilds 89 rows,
so everything matches up. Weird. Also, there was a guy who originally posed this question on experts-exchange. He says that he has multiple ( at least 10) databases that are clones of eachother yet in some databases he gets the result I am getting and in others he gets no triggers in dba_source. A mystery. Received on Wed Sep 18 2002 - 15:54:57 CDT

Re: DBA_SOURCE vs DBA_TRIGGERS