Compressing a schema in multi user schema Oracle 11g geodatabase

448
1
10-03-2018 12:52 PM
SOVANHALDER
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
KevinDunlop
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.