AnsweredAssumed Answered

Offline editing - getting multiple records in sqldeveloper for Query layer

Question asked by mukesh2803 on Mar 18, 2015

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

Attachments

Outcomes