topic Re: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table in Geodatabase Questions

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

JoseSanchez — Tue, 27 Dec 2016 18:08:09 GMT

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;

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

JoshuaBixby — Tue, 27 Dec 2016 19:14:11 GMT

What version of Oracle? What version of ArcGIS? Using ST_Geometry, SDO_Geometry, or compressed binary? How was the view created, using ArcCatalog, the old SDE command line tools, etc...?

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

JoseSanchez — Tue, 27 Dec 2016 19:52:42 GMT

The version of Oracle is 11G but we upgraded this week to 12C.

ArcGIS Client 10.2.2

ArcSDE 10.2

Using ST_Geometry

For testing purposes we created the two views with the same code using the old SDE command line, and ArcCatalog View. Both show the same error message.

Thanks