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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2014

Added on Mar 31 2014

#general-database-discussions

7 comments

1,099 views