Cannot delete from view without exactly one key preserved table

Question

I have to run a script for a company. I just get the same error every time.

The query:

DELETE FROM WMO
WHERE (clientnr = ****** AND number_message = *****) 

The error:

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

What did I wrong?

Thnx!

Answer 1

Database views are in general projection of one or more tables. It is a SELECT statement over one or more tables to be specific. For database engine it is impossible to decide what it should delete and from which table unless the view is constructed from single table.

The best solution is to run DELETE command against tables that are used to construct the view.

Additional information:

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