ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
I am running a query on Oracle 10G database.
Why this error occurs and what is a key-preserved table.
If I run the query without the view it runs.
When I join the view to the query I get the error.
Can you help resolving this.
Thanks and Regards
Madana