topic Compressing a schema in multi user schema Oracle 11g geodatabase in Geodatabase Questions

Compressing a schema in multi user schema Oracle 11g geodatabase

SOVANHALDER — Wed, 03 Oct 2018 19:52:20 GMT

Hi,

We need to compress a schema in multi user schema Oracle 11g Geodatabase. To accomplish this task we will connect to the particular schema using ArcCatalog and run the Compress from Geodatabase Administration. My question is will it only compress the particular schema or all the user schemas ?

Re: Compressing a schema in multi user schema Oracle 11g geodatabase

KevinDunlop — Thu, 04 Oct 2018 14:54:46 GMT

When you say multi user schemas do you mean having 1 geodatabase with multiple data owners or have multiple geodatabases in the same oracle database? For the first, only the SDE user can compress so it will compress everything. For the latter, the geodatabases are independent of each other so you should compress each of them.