madana
Oct 1, 2009, 01:39 AM
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
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