Offline editing - getting multiple records in sqldeveloper for Query layer

3618
0
03-18-2015 01:47 AM
MukeshA
New Contributor II

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

Tags (1)
0 Kudos
0 Replies