Thursday, July 2, 2015

ORA-04045: errors during recompilation/revalidation of ODSSTG.ODSPREBXE_STREAMS_LOGON

Verify if the object exists

select object_name, object_type, status, owner from dba_objects where object_name='ODSPREBXE_STREAMS_LOGON';

If the object status shows as invalid.

Compile as below.

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
----------------------------------------------------------------------------
STATUS                       OWNER
---------------------------- ------------------------------
ODSPREBXE_STREAMS_LOGON
TRIGGER
INVALID                      ODSSTG


22:54:24 SQL> alter trigger ODSSTG.ODSPREBXE_STREAMS_LOGON COMPILE;

Trigger altered.

Elapsed: 00:00:00.09

After the compilations the error is stopped in the alert log.


No comments:

Post a Comment