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

NNL-00036: No records loaded

1 Answers  


ORA-07626: smsget: sga already mapped

1 Answers  


NNL-00541: set|show trace_level [<level>] [<server_list>] : set|show the server's tracing level

1 Answers  


PCB-00555: Using WHERE CURRENT OF on cursor defined without FOR UPDATE clause

1 Answers  


ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.

1 Answers  






RMAN-08543: channel string: specifying archivelog(s) for proxy backup

1 Answers  


PLS-00590: attempting to create a subtype UNDER a FINAL type

1 Answers  


SQL*Loader-00284: Warning: Input data file string specified multiple times.

1 Answers  


ORA-01116: error in opening database file string

1 Answers  


ORA-06812: TLI Driver: could not read the ethernet driver's node address

1 Answers  


CLSR-01010: Unable to record PMON pid to string

1 Answers  


ORA-30036: unable to extend segment by string in undo tablespace 'string'

1 Answers  


Categories