AnsweredAssumed Answered

ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

Question asked by jsn on Dec 27, 2016
Latest reply on Dec 27, 2016 by jsn

Hello everyone,

 

When opening a SDE view directly in oracle with Oracle SQL Developer to see the Data we get the following error message: 

ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

 

The SDE view shows correctly in ArcCatalog but now in SQL Developer  we get this error message.

It looks like the error is caused by the field "SHAPE", because removing this field allows to Open the view and see the data.

 

SELECT FC.SHAPE,
    FC.OBJECTID,
    FC.ProjectID,
    TableView.STATUS,
    TableView.PROJECTNAME,
    TableView.PROJECTLOCATION,
    TableView.PROJECTDESCRIPTION
  FROM APP.FC,
    APP.TableView
  WHERE FC.ProjectID IS NOT NULL
  AND FC.ProjectID    = TableView.ProjectID;

Outcomes