Offline editing - getting multiple records in sqldeveloper for Query layer

MukeshA — Wed, 18 Mar 2015 08:47:54 GMT

Hello,

I have created one layer for offline editing ex. EXISTINGQUARRY, added 2 features to the layer (EXISTINGQUARRY) from ArcMap. When I open the attribute table I can see 2 records (screenshot1)

When I see the table from SQLDeveloper with following command – select * from EXISTINGQUARRY,

around 10 rows are seen in the table. (Screenshot2)

I want to know why this is happening, because when I create a query layer I am getting many repeated records for the 2 features.

Noticed that a View is created in Oracle with name EXISTINGQUARRY_EVW if I query this I can see only 2 records as it is seen through attribute table in ArcMap. Want to know why is this happening, is this the expected behaviour or am I doing some mistake?

Softwares used:

ArcGIS Desktop 10.2.2

ArcGIS Server 10.2.2

Oracle 11.2.0.1

topic Offline editing - getting multiple records in sqldeveloper for Query layer in Geodatabase Questions

Offline editing - getting multiple records in sqldeveloper for Query layer