A quick tour of geodatabases in Oracle
A quick tour of setting up a geodatabase in Oracle
System requirements to install ArcSDE for Oracle
Oracle initialization parameters
The sde operating system account on Linux or UNIX
Setting variables for the sde OS user on Linux or UNIX
Creating the sde user and tablespace in Oracle
Installing ArcSDE for Oracle on Linux or UNIX
Creating a geodatabase in Oracle on Linux or UNIX
Authorizing ArcSDE geodatabases in Oracle on Linux or UNIX
Installing ArcSDE for Oracle on Windows
Creating a geodatabase in Oracle on Windows
Authorizing ArcSDE geodatabases in Oracle on Windows
Creating and starting an ArcSDE service for geodatabases in Oracle on Windows
Installing Oracle and ArcSDE on separate servers
Multiple geodatabases in Oracle
The relationship between the master geodatabase and user-schema geodatabases in Oracle
Creating a geodatabase in a user's schema in Oracle
Configuring the Oracle listener to access the geodatabase with SQL
Starting a remote ArcSDE service on Windows
Setting up multiple ArcSDE services on one Linux or UNIX server
Setting up multiple ArcSDE services on one Windows server
What is geodatabase configuration?
The giomgr.defs file and the SERVER_CONFIG system table
Buffer size initialization parameters
Altering SERVER_CONFIG parameters before the geodatabase is created
Altering SERVER_CONFIG parameters after the geodatabase is created
What are ArcSDE log file tables?
Log file table configuration options for geodatabases in Oracle
In what order do ArcSDE log file types get used?
The services.sde file
The dbinit.sde file
Environment variables
Language settings for ArcSDE XML columns in geodatabases in Oracle
Configuring an Oracle database to support ArcSDE XML columns
What is the dbtune file?
What is the DBTUNE table?
What are DBTUNE configuration keywords and parameters?
Oracle DBTUNE configuration parameters
Oracle Spatial DBTUNE storage parameters
Types of configuration keywords
Default configuration keywords specific to Oracle
The DEFAULTS keyword in Oracle
The DATA_DICTIONARY keyword in Oracle
The LOGFILE_DEFAULTS keyword in Oracle
Composite keywords and geometry storage
Custom configuration keywords
Altering the dbtune file before creating the geodatabase
Altering the contents of the DBTUNE table after it has been created
Making configuration keywords available in ArcGIS
Minimize disk I/O contention in Oracle
Memory tuning in Oracle
Scripts to tune an Oracle instance for ArcSDE XML storage
What are user accounts?
A quick tour of user accounts
The ArcSDE administrative account in Oracle
User groups or roles
Tips for grouping users
Operating system authentication
What are user permissions?
User permissions for geodatabases in Oracle
Granting and revoking privileges on datasets
A quick tour of connections to ArcSDE geodatabases
Geodatabase connections in ArcGIS Desktop
Connections to user-schema geodatabases in Oracle
Connecting to a specific geodatabase version
Preparing database connection files
Preventing users from connecting to a geodatabase
Making a connection from ArcIMS to a geodatabase in Oracle
What is a direct connection to a geodatabase in Oracle?
What are direct-connect drivers?
Direct-connect compatibility between clients and ArcSDE geodatabases in Oracle
Setting up a direct connection to Oracle
Making a direct connection from ArcGIS Desktop to a geodatabase in Oracle
Direct connections from ArcSDE commands to a geodatabase in Oracle
Removing direct connections from the geodatabase
Troubleshooting direct connections to an ArcSDE geodatabase
What is an ArcSDE service?
A quick tour of ArcSDE services
Compatibility between clients and geodatabases in Oracle when using an ArcSDE service
Making an ArcSDE service connection from ArcGIS Desktop to a geodatabase in Oracle
Removing an ArcSDE service connection from the geodatabase
Displaying ArcSDE service statistics
Displaying connected sessions
ArcSDE services inside a firewall
Forcing a search of the local services file on UNIX systems
Troubleshooting an ArcSDE service
Creating an ArcSDE service on Windows using the sdeservice command
Creating an ArcSDE service from a remote Windows server
Starting a local ArcSDE service on Windows
Starting a remote ArcSDE service on Windows
Stopping a local ArcSDE service on Windows
Stopping a remote ArcSDE service
Pausing a local ArcSDE service on Windows
Pausing an ArcSDE service using sdemon
Resuming a local ArcSDE service on Windows
Resuming an ArcSDE service using sdemon
Registering an ArcSDE service on UNIX or Linux
Starting a local ArcSDE service on UNIX or Linux
Starting a remote ArcSDE service on Linux or UNIX
Stopping a local ArcSDE service on Linux or UNIX
Stopping a remote ArcSDE service
Pausing an ArcSDE service using sdemon
Resuming an ArcSDE service using sdemon
Shutting down a stalled giomgr process on UNIX or Linux
What type of maintenance is needed for a geodatabase?
Database backup and recovery
Oracle backups
Recovery models for Oracle
Geodatabase version administration
The geodatabase compress operation
Adding the Compress command to ArcCatalog
Compressing an ArcSDE geodatabase licensed under ArcGIS Server Enterprise
Database statistics
Updating statistics on a geodatabase using the Analyze command
Statistics in Oracle databases
User-schema geodatabase management
Deleting a geodatabase from a user's schema
A quick tour of ArcSDE geodatabase upgrades
What is a service pack or patch?
Preparing to upgrade a geodatabase in Oracle
Uninstalling ArcSDE from Linux or UNIX
Uninstalling ArcSDE from Windows
Configuring the Oracle listener to access the geodatabase with SQL
Upgrading an ArcSDE geodatabase in Oracle
Upgrading geodatabases in user schemas in Oracle
Upgrade Geodatabase
Scripting an ArcSDE geodatabase upgrade in Oracle
Upgrade Network
Upgrade Parcel Fabric
Migrating to ArcSDE 64 bit on Linux or UNIX when the existing DBMS is 64 bit
Migrating to ArcSDE 64 bit on Linux or UNIX when the existing DBMS is 32 bit
Migrating to ArcSDE 64 bit on Windows when the existing DBMS is 32 bit
Migrating to ArcSDE 64 bit on Windows when the existing DBMS is 64 bit
Moving a geodatabase using ArcSDE export files
Moving a geodatabase using an XML document
Other methods for moving a geodatabase in Oracle
What's inside a geodatabase in Oracle?
A comparison of ArcGIS, ArcSDE, and Oracle data types
What are user-defined data types?
What is the ST_Geometry storage type?
ST_Geometry storage in Oracle
ST_Geometry generated from well-known text and well-known binary data
ArcSDE compressed binary storage
The OGC Well-Known Binary representation for geometry
What is Oracle Spatial?
How does ArcSDE use Oracle Spatial?
What happens when you create feature classes with SDO_GEOMETRY geometry storage?
Raster storage types in an ArcSDE geodatabase
What is the ST_Raster storage type?
ArcSDE and the Oracle Spatial raster type
BLOB data storage in geodatabases in Oracle
XML columns in a geodatabase stored in Oracle
Language settings for ArcSDE XML columns in geodatabases in Oracle
What are XML schemas in ArcSDE geodatabases?
Registering a third-party table containing a spatial column
Tips on registering existing tables with an ST_Geometry column
Data migration from one storage type to another
Migrating LONG RAW attribute columns in Oracle using ArcSDE commands
Migrating geometry from one storage type to another using ArcSDE commands
Migrating raster columns using ArcSDE commands
Migrating raster columns to the ST_Raster type using the Migrate Storage geoprocessing tool
Feature classes in a geodatabase in Oracle
Subtypes in feature classes in a geodatabase in Oracle
Domains in a geodatabase stored in Oracle
Feature datasets in a geodatabase in Oracle
Topologies in a geodatabase in Oracle
Geometric networks in a geodatabase in Oracle
Network datasets in a geodatabase in Oracle
Parcel fabrics in a geodatabase in Oracle
Schematic datasets in a geodatabase in Oracle
Terrain datasets in a geodatabase in Oracle
Relationships between datasets in a geodatabase in Oracle
Locators in a geodatabase stored in Oracle
Toolboxes in geodatabases in Oracle
Raster datasets and raster catalogs in a geodatabase stored in Oracle
Mosaic datasets in a geodatabase in Oracle
Versioned tables in a geodatabase in Oracle
Replicas in a geodatabase in Oracle
Archives in a geodatabase in Oracle
Keyset tables in a geodatabase in Oracle
ArcSDE log file tables in a geodatabase in Oracle
System tables of a geodatabase stored in Oracle
What is a view?
A quick tour of views in the geodatabase
Views in Oracle
Example: Creating a database view in Oracle using SQL and registering it with ArcSDE
Example: Creating a database view in Oracle using the sdetable command
Example: Creating a spatial view in Oracle using SQL and registering it
Example: Creating spatial views in Oracle using the sdetable command