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

TNS-12550: TNS:syntax error

1 Answers  


ORA-38413: elementary attribute name may not be longer than 32 characters

1 Answers  


ORA-12438: repeated policy option: string

1 Answers  


QSM-01063: query has a dictionary table or view

1 Answers  


RMAN-08580: channel string: starting datafile copy

1 Answers  






ORA-30691: failed to allocate system resources while registering a TCP/IP connection for data traffic detection

1 Answers  


ORA-25262: agent name cannot be NULL if address is a multi-consumer queue

1 Answers  


ORA-39039: Schema expression "string" contains no valid schemas.

1 Answers  


ORA-14323: cannot add partition when DEFAULT partition exists

1 Answers  


PLS-00618: type mismatch found at 'string' between operands in a NULLIF expression

1 Answers  


PCB-00631: Host variable is not an External LOB

1 Answers  


LPX-00005: ~1s buffer overflow, maximum size is ~2u bytes

1 Answers  


Categories