The relationship between the master geodatabase and user-schema geodatabases in Oracle

Geodatabases you create in the schema of a user other than the sde user in an ArcSDE for Oracle geodatabase are not entirely self-contained; there is some functionality, such as the ArcSDE service or user-defined types, that are only in the master sde geodatabase. For that reason, you cannot treat geodatabases in users' schemas as their own entity, and the following rules apply:

Based on these rules, the following release and connection scenarios are possible:

ArcGIS 9.2 SP5 or SP6 clients

When using a version 9.2 SP5 or SP6 client, connections for specific release geodatabases are as follows:

Master/User-schema geodatabase release

Direct connection or ArcSDE service

Direct connection only

No connection possible

9.2 master sde geodatabase

checkmark

9.2 user-schema geodatabase in a 9.2 master geodatabase

checkmark

9.3.x master sde geodatabase

checkmark

9.3.x user-schema geodatabase in a 9.3.x master geodatabase

checkmark

9.2 user-schema geodatabase in a 9.3.x master geodatabase

checkmark

10 master sde geodatabase

checkmark

10 user-schema geodatabase in a 10 master geodatabase

checkmark

9.3.x user-schema geodatabase in a 10 master geodatabase

checkmark

9.2 user-schema geodatabase in a 10 master geodatabase

checkmark

ArcGIS 9.3.x clients

When using a version 9.3.x client, connections for specific release geodatabases are as follows:

Master/user-schema geodatabase release

Direct connection or ArcSDE service

Direct connection only

No connection possible

9.2 master sde geodatabase

checkmark

9.2 user-schema geodatabase in a 9.2 master geodatabase

checkmark

9.3.x master sde geodatabase

checkmark

9.3.x user-schema geodatabase in a 9.3.x master geodatabase

checkmark

9.2 user-schema geodatabase in a 9.3.x master geodatabase

checkmark

10 master sde geodatabase

checkmark

10 user-schema geodatabase in a 10 master geodatabase

checkmark

9.3.x user-schema geodatabase in a 10 master geodatabase

Possible from 9.3.1 SP1 or SP2 client

9.2 user-schema geodatabase in a 10 master geodatabase

Possible from 9.3.1 SP1 or SP2 client

ArcGIS 10 clients

When using a version 10 client, connections for specific release geodatabases are as follows:

Master/User-schema geodatabase release

Direct connection or ArcSDE service

Direct connection only

9.2 master sde geodatabase

checkmark

9.2 user-schema geodatabase in a 9.2 master geodatabase

checkmark

9.3.x master sde geodatabase

checkmark

9.3.x user-schema geodatabase in a 9.3.x master geodatabase

checkmark

9.2 user-schema geodatabase in a 9.3.x master geodatabase

checkmark

10 master sde geodatabase

checkmark

10 user-schema geodatabase in a 10 master geodatabase

checkmark

9.3.x user-schema geodatabase in a 10 master geodatabase

checkmark

9.2 user-schema geodatabase in a 10 master geodatabase

checkmark

Related Topics


11/18/2013