PROBLEM
When registering an Oracle Spatial table as versioned, the SDE user is not being granted all privileges on the spatial index table. This prevents the SDE user from being able to compress or edit.
ArcSDE needs to assign permissions to the SDE user to allow compress to continue. This problem is fixed in ArcSDE 9.0.
Article ID: 000008393
Get help from ArcGIS experts
Download the Esri Support App