ORA-01752: cannot delete from view without exactly one
key-preserved table



ORA-01752: cannot delete from view without exactly one key-preserved table..

Answer / guest

Cause: The deleted table either had no key perserved tables,
had more than one key-preserved table, or the key-preserved
table was an unmerged view or a table from a read-only view.

Action: Redefine the view or delete it from the underlying
base tables.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-12511: use ctx_ddl.create_stoplist to create stoplists

1 Answers  


NZE-28822: Required seed is not specified.

1 Answers  


ORA-01548: active rollback segment 'string' found, terminate dropping tablespace

1 Answers  


ORA-13250: insufficient privileges to modify metadata table entries

1 Answers  


SQL*Loader-00259: Could not escalate DDL share lock to exclusive on table string

1 Answers  






EXP-00033: Could not find environment character set

1 Answers  


ORA-25190: an index-organized table maintenance operation may not be combined with other operations

1 Answers  


PCC-02113: DBMS=V6 no longer supported; using DBMS=NATIVE, CHAR_MAP=VARCHAR2.

1 Answers  


LSX-00330: missing range start character

1 Answers  


ORA-16182: Internal error on internal channel during remote archival

1 Answers  


PCB-00003: Value of DBMS option invalid with given value of MODE option

1 Answers  


ORA-02054: transaction string in-doubt

1 Answers  


Categories