After compressing the database, the alpha table is not empty. I could still see the record inside the table.
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.
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.