ORA-01779: cannot modify a column which maps to a non
key-preserved table



ORA-01779: cannot modify a column which maps to a non key-preserved table..

Answer / guest

Cause: An attempt was made to insert or update columns of a
join view which map to a non-key-preserved table.

Action: Modify the underlying base tables directly.

Please add more information about this Error

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00117: Internal error- No data passed through pump

1 Answers  


ORA-29552: verification warning: string

1 Answers  


SQL*Loader-00901: Error logging on to ORACLE:

1 Answers  


ORA-25130: cannot modify primary key - primary key not defined for table

1 Answers  


ORA-13143: invalid POLYGON window definition

1 Answers  






ORA-36676: (XSDPART14) Missing dimension list for string.

1 Answers  


ORA-32134: Cannot assign LOBs

1 Answers  


ORA-24099: operation not allowed for 8.0 compatible queues

1 Answers  


AMD-00134: measure #string: RDBMS measure column name not specified

1 Answers  


SQL-02142: Collection is NULL

1 Answers  


ORA-25291: Buffer does not exist for the specified queue

1 Answers  


SQL*Loader-00460: Column (string), form of use (number) does not match char set id of (number)

1 Answers  


Categories