Select to view content in your preferred language

Compressing a schema in multi user schema Oracle 11g geodatabase

10-03-2018 12:52 PM
New Contributor III


 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 ?


1 Reply
Occasional Contributor III

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.