ORA-04099: trigger 'string' is valid but not stored in
compiled form



ORA-04099: trigger 'string' is valid but not stored in compiled form..

Answer / guest

Cause: A trigger was attempted to be retrieved for execution
and was found to be valid, but not stored. This may mean the
an upgrade was done improperly from a non-stored trigger
release.

Action: Alter compile the trigger to create the trigger in
stored form. Also, you may want to review that a proper
upgrade was done.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-28767: invalid version number

1 Answers  


LCD-00207: nested parentheses encountered [string]

1 Answers  


RMAN-06747: at least 1 channel of tertiary storage must be allocated to execute this command

1 Answers  


ORA-23533: object "string"."string" can not be cached

1 Answers  


ORA-14056: partition number string: sum of PCTUSED and PCTFREE may not exceed 100

1 Answers  


ORA-37021: (XSMULTI02) Object workspace object is not acquired.

1 Answers  


PCC-02339: host variables cannot be of union types

1 Answers  


QSM-00770: the specified workload string is already referenced by task string

1 Answers  


CLSR-00509: Unable to initialize NLS

1 Answers  


LPX-00229: input source is empty

1 Answers  


ORA-09890: osnTXtt: malloc failed

1 Answers  


ORA-13031: Invalid Gtype in the SDO_GEOMETRY object for point object

1 Answers  


Categories