ORA-30502: system triggers cannot have INSERT, UPDATE, or
DELETE as triggering events



ORA-30502: system triggers cannot have INSERT, UPDATE, or DELETE as triggering events..

Answer / guest

Cause: An attempt was made to create a system trigger with
INSERT, UPDATE, or DELETE triggering events, but this type
of trigger is not supported because a system trigger does
not have a base table.

Action: Do not attempt to create a system trigger with
INSERT, UPDATE, or DELETE triggering events.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00241: invalid external type specification for SQLSTATE

1 Answers  


QSM-02075: materialized view on synonym

1 Answers  


ORA-07580: spstp: $GETJPIW failure

1 Answers  


ORA-13509: error encountered during updates to a SWRF table

1 Answers  


ORA-27413: repeat interval is too long

1 Answers  






ORA-16806: Supplemental logging is not turned on.

1 Answers  


SQL*Loader-00939: OCI error while string for table string partition string

1 Answers  


ORA-31451: invalid value string for capture_values, expecting: OLD, NEW, or BOTH

1 Answers  


ORA-32821: subscriber queue and exception queue must have same payload type

1 Answers  


ORA-19609: %s is from different backup set: stamp string count string

1 Answers  


DRG-11616: URL store: too many redirections trying to access string

1 Answers  


ORA-24415: Missing or null username.

1 Answers  


Categories