While trying to insert on views i get the error
ERROR at line 1:
ORA-01779: cannot modify a column which maps to a non key-preserved table
pls advice should be done.
Printable View
While trying to insert on views i get the error
ERROR at line 1:
ORA-01779: cannot modify a column which maps to a non key-preserved table
pls advice should be done.
Verify two things
1. Is the view made from a select statement from 2 or more tables ?
2. If the view is created from 1 table does it contain all the not null columns. ?