ORA-25005: cannot CREATE INSTEAD OF trigger on a read-only view



ORA-25005: cannot CREATE INSTEAD OF trigger on a read-only view..

Answer / guest

Cause: attempt to create an INSTEAD OF trigger on a view
created with read-only option. The view cannot be updated
using INSTEAD OF triggers.

Action: Do not create the trigger.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

DRG-10011: invalid object name string

1 Answers  


ORA-01947: TEMPORARY TABLESPACE already specified

1 Answers  


LPX-00320: No more attributes can be added to a non empty element

1 Answers  


DRG-11852: Can't Locate Remote Host

1 Answers  


PLS-00307: too many declarations of 'string' match this call

1 Answers  






NNO-00252: invalid administrative region parameter string value "string"

1 Answers  


ORA-25472: maximum open iterators exceeded

1 Answers  


ORA-40206: invalid setting value for setting name string

1 Answers  


NNO-00612: enabling request forwarding

1 Answers  


QSM-02055: mv references a packed object table or view

1 Answers  


ORA-36883: (XSSRF02) The first parameter of an AW single row function cannot be NULL.

1 Answers  


RMAN-10034: unhandled exception during execution of job step number, error unknown

1 Answers  


Categories