We face problem on displaying feature class in Oracle, which successfully imported from file geodatabase using Append (Data Management) Tools, my experiment on copying it to Postgre no problem on displaying it.
Is this problem on permission setting in Oracle ? If we select the record, selected object appears.
I attach the capture screen related to the problem, [ATTACH=CONFIG]24314[/ATTACH]
You're missing quite a number of details that are critical to getting assistance.
What version of ArcGIS are you using? What service pack?
What database are you using? (exact release to four places)
What storage type are you using?
If you're using SDO_GEOMETRY, how have you defined the USER_SDO_GEOM_METADATA?
What is the spatial extent of the layer?
While screenshots can be useful in some situations, it's critically important to get the text of relevant error messages in your post -- This allows search engines to find the content, and help the next person with the same problem. This particular error message is unrelated to the problem (you can't edit without a spatial index).
Since you can't ever "fix" the problem of editing a layer in Load-Only I/O mode, let's work on addressing the missing geometries. I can't help but wonder if the version tree has been mangled, since I don't think you're supposed to be able to place a layer in load-only I/O mode while versioned. This is probably an issue to take to Tech Support, but I can take one more stab at it before placing you in their more capable hands.
What I don't undersand is: if I create a new SDE feature class, register it as versioned and load data, the feature class doesn't have a Spatial Index but displays correctly and can be edited. it seems it is not in Load Only I/O mode
So, why does adding a Spatial Index and deleting it later on changes the feature class in Load Only I/O mode?