Compressing a schema in multi user schema Oracle 11g geodatabase

128
1
10-03-2018 12:52 PM
Highlighted
New Contributor III

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

1 Reply
Highlighted
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.