Compressing a schema in multi user schema Oracle 11g geodatabase

SOVANHALDER

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 ?

S

KevinDunlop

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.