Oracle Table and Materialized View with Same Name - How to Update the Table
Posted on 2014-01-23
Hi, probably another super easy one...
My client named a materialized view the same as his table. When I try to insert into the table, I get "ORA-01732: data manipulation operation not legal on this view" since it just assumes I mean the view.
How do I tell it insert into the table? Is there some way to do like INSERT INTO schema.alltables.tablename (.. or something? So it knows I mean the table and not the view?
I don't have the option of dropping or changing the view. It's the client's setup, as dumb as it may be. :(