Database Administration (MOSC)

MOSC Banner

Error coming while update the base table of mview

edited Oct 25, 2013 8:01PM in Database Administration (MOSC) 3 commentsAnswered
 Below Error coming while update the base table of mview
update coco_component_postit_v set text16=upper(text16); 

 
[Error] Execution (24: 36): ORA-01779: cannot modify a column which maps to a non key-preserved table


Best regrads,
Vishal

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center