ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
I am trying to create a view of 3 tables but I keep getting the error:
ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
It works as a select statement and as a materialized view, but I require that the view be dynamic.
Each of the three tables has a Primary Key and one of the tables is spatial. I realize that there is the possibility of duplicate records, but there aren't any at the moment.
The tables are:
PED_MEDIAN_STRIPID - primary keyLOCATION_ID - unique but not currently set with a constraintGEOMETRY - sdo_geometryPED_MEDIAN_STRIP_SPONSORSID - primary keySPONSOR_ID - unique but not currently set with a constraintCOMPANY - VARCHAR2(100)PED_MEDIAN_STRIP_ORDERSID - primary keyORDER_ID - unique but not currently set with a constraintLOCATION_ID - should be a foreign keySPONSOR_ID - should be a foreign keyAMOUNT_SPONSORED - number(10,2)The view is:CREATE OR REPLACE FORCE VIEW PED_MEDIAN_STRIP_V AS0