Hi All,
I'm running ArcSDE 9.3.1 on Oracle 10g.
I have a spatial view, created with sdetable -o create_view, from a feature class and a table.
I have one feature in the feature class and 3 corresponding records for it in the table.
After I create the view, in Oraccle it show 3 records (which is normal and correct), all with same geometry.
But when I load it in ArcCatalog or ArcMap, it show only one record (the first), the other 2, with duplicate geometry are not shown. The view, by default, it's made with INNER JOIN.
Has someone any idea why that's happening?
I really have to shown also records with duplicate geometry, even if they are overlapping. I can have the same parcel belonging to 2 groups, in the same time.
Regards
Andrei Gosman