Compress Database in Oracle- ArcGIS 10.1

Question

After compressing the database, the alpha table is not empty. I could still see the record inside the table.

Steps Taken:

1. Reconcile and post all the versions

2. Delete all the versions

3. Compress the database using the compress geo-processing tool

4. checked the compress_log table and found that the compress is successful.

Please help me to fix this issue.

Thank You,

Adham

JakeSkinner · Answer

Hi Adham,

If you have any replicas, make sure they are synchronized.  Also, you will want to make sure that there are no users connected, and no locks within the geodatabase.  You can check this by right-clicking on the geodatabase > Administration > Administer Geodatabase.