topic Re: Compress not available in Geodatabase Questions

Compress not available

Stefan_Offermann — Fri, 11 Nov 2022 14:04:06 GMT

We have a new Oracle 19c Geodatabase and ArcGIS 10.7.1, but cannot run the compress on the user because the context menu is gray:

The license level is ok, it works on migrated users from an old Oracle 12.2 instance.

Re: Compress not available

MarceloMarques — Fri, 11 Nov 2022 19:17:33 GMT

1. make sure you are connected as the sde user

only the sde user can perform a sde compress

open the geodatabase connection file properties to check if you are connecting as the sde user

2. if you are connected as the sde user and the option is still gray out, then do not panic, simply on the catalog view click on another folder then click back in the connection file of the sde user, this will refresh and the sde compress shall be enabled in the context menu, another alternative is to use the GP Tool to perform the sde compress, in the Toolbox search for the "compress geodatabase" tool.

Re: Compress not available

Stefan_Offermann — Mon, 14 Nov 2022 06:49:43 GMT

@MarceloMarques wrote:
1. make sure you are connected as the sde user
only the sde user can perform a sde compress

This solved my problem!

I think the reason for my migrated users is that they are user-schema-geodatabases and therefor the compress can be started with the individual (old) user, not sde. I created one new user, with a master-sde-geodatabase, so this time I have to use the sde user instead of the individual user. Is this correct?

Re: Compress not available

MarceloMarques — Mon, 14 Nov 2022 16:30:10 GMT

@Stefan_Offermann Yes, with the sde master geodatabase only the sde user can perform the sde compress, and in an user-schema geodatabases only the user-schema geodatabase owner can perform the sde compress.

Note, you might already know this, the user-schema geodatabases are now deprecated and for consolidation the path forward is to use Oracle Multi-Tenant CDB and PDBs.

read more in my blog at community.esri.com

Mapping and Charting Solutions (MCS) Enterprise Da... - Esri Community

Database Template Scripts