I have the following two objects in the schema
SQL> SELECT OWNER,object_type, object_name from dba_objects where object_name='TABLE_REP';
OWNER OBJECT_TYPE
------------------------------ -------------------
OBJECT_NAME
--------------------------------------------------------------------------------
ccde TABLE
TABLE_REP
ccde MATERIALIZED VIEW
TABLE_REP
when I doing the following update query
SQL> update ccde.table_rep set cid='50' where name='md_test';
I got the following error,
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view
So what's order of the db taking the objects for the update?