Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to update the underlying table instead of updating the same name view

haoMar 31 2014 — edited Mar 31 2014

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?

This post has been answered by JustinCave on Mar 31 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2014
Added on Mar 31 2014
7 comments
1,097 views