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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Viewing source code of a trigger

Re: Viewing source code of a trigger

From: Robert Chung <robertch_at_mindspring.com>
Date: Wed, 02 Sep 1998 03:18:05 GMT
Message-ID: <35ebed57.662893@news.mindspring.com>


>Robert Chung wrote in message <35eb1354.33711214_at_news.mindspring.com>...
>>
>>I need to take a look at the source code of a particular trigger that
>>is slowing down our database big time. I am trying to see the code
>>using TRIGGER$ data dictionary view. However, this table displays
>>only a couple of lines of the code and does not let you see the rest
>>of the code. Is there some other way to see the code? (possibly with
>>other data dictionary view?) Thank you in advance.
>>
>>
>

On 1 Sep 1998 00:27:51 GMT, "Madhu Cherukuri" <madhuc_at_hotmail.com> wrote:

>Look at SYS.DBA_TRIGGERS
>You should find code in that table
>
>Madhu Cherukuri
>
>

Thank you Madhu. However, I still have exactly the same problem with DBA_TRIGGERS as TRIGGER$. Am I doing something wrong? Received on Tue Sep 01 1998 - 22:18:05 CDT

Original text of this message

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