Problem: ArcSDE 8.1 pre-SP1 for Oracle Spatial has problems processing multipart points
ArcSDE for Oracle Spatial does not always process multipart point features correctly. Multipart point features may not be returned to an application during a query operation.
This is a known issue and only occurs at ArcSDE 8.1 (and earlier) for Oracle Spatial.
Solution or Workaround
Upgrade to ArcSDE 8.1 SP1 or later.
Substitute multiple single-part points for the multipart points. This option would add rows to the feature classes and change the normalization of your database. This is not suitable for many applications.