Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Viewing source code of a trigger
>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
![]() |
![]() |