1 of 1 people found this helpful
In general, the MM_ tables should NEVER be registered as versioned. If they are, you should unregister them. In theory, I can't see any reason why a compress would touch the MM_Persist_info table if the table wasn't registered as versioned.
You used the REGISTRATION_ID to get the table_name, but with the S table, that is incorrect. You should use the SDE.LAYERS table to get the S table.
select table_name from sde.layers where layer_id = 165; -- This will give you the proper layer name.
F and S table values come from LAYER_ID on the SDE.LAYERS table;
A and D table values come from the REGISTRATION_ID on the SDE.TABLE_REGISTRY table.
Hope this helps,
Thanks for the tips. After I looked at it, I was pretty sure it wasn't the MM_Tables, but I did not know abou tthe LAyer_ID in the SDE.Layers table, so that was very helpful.
And our MM_Tables aren't registered as versioned.