Why we can't perform DML operations on Materialized views???

Question Posted / naren

Why we can't perform DML operations on Materialized views???..

Answer / saikiran

we can manipulate the materialized view using triggers function concept

Is This Answer Correct ?

13 Yes

2 No

More Oracle Errors Interview Questions

PLS-00571: method access through data base link not yet supported on client side

ORA-39147: cannot migrate Data Pump queue table ownership to this instance

TNS-00541: underlying transport does not exist.

ORA-24344: success with compilation error

EXP-00010: %s is not a valid username

ORA-26508: null materialized view connection

SQL-02112: SELECT..INTO returns too many rows

ORA-25276: table specified is not a queue table

RMAN-05502: the target database must be mounted when issuing a DUPLICATE command

PCB-00011: DBMS=V6 no longer supported; using DBMS=NATIVE

DRG-50907: score threshold string outside valid range 1 to 100

PLS-00247: LIBRARY name must be specified

For more Oracle Errors Interview Questions Click Here