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

ORA-27003: cannot open file on device allocated with NOIO option

1 Answers  


QSM-01098: mv string clause more restrictive than query string clause

1 Answers  


ORA-30658: attempt was made to create a temporary table with EXTERNAL organization

1 Answers  


NNF-01002: DCE could not open configuration file

1 Answers  


NNL-00812: Slowest query processing time: string

1 Answers  






DRG-10832: can not delete from feedback table string

1 Answers  


ORA-29347: Tablespace name validation failed - failed to match tablespace 'string'

1 Answers  


ORA-23402: refresh was aborted because of conflicts caused by deferred txns

1 Answers  


PLS-00614: creating a FINAL NOT INSTANTIABLE type

1 Answers  


ORA-19551: device is busy, device type: string, device name: string

1 Answers  


ORA-23435: cannot create an updatable ROWID materialized view with LOB columns

1 Answers  


ORA-13449: GeoRaster metadata ULTCoordinate error

1 Answers  


Categories