Re: Trigger Compilation Problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 15 Jan 2001 18:58:05 +0100
Message-ID: <t672ktmjatsl56@beta-news.demon.nl>

select * from dba_errors where name = 'TAUDIT_ACCOUNT_HOLIDAY' and owner = 'EL_OWNER'

Hth,

Sybrand Bakker, Oracle DBA

"Leor Amikam" <amikam_at_mindspring.com> wrote in message news:93v5ip$otj$1_at_slb6.atl.mindspring.net...
> I moved my 8.0.5 system to a new machine using export, and messed-up
> something.
> Now, when I try to compile certain triggers, I get this:
>
> MGR-00073: Warning: TRIGGER EL_OWNER.TAUDIT_ACCOUNT_HOLIDAY created with
> compilation errors.
>
> When I try to look at the errors, I get this:
> SQLWKS> show errors
> No errors for TRIGGER EL_OWNER.TAUDIT_ACCOUNT_HOLIDAY
>
> How do I find out why my trigger won't compile?
>
> Thanks,
> Leor Amikam
>
>
Received on Mon Jan 15 2001 - 11:58:05 CST