Specifics of working with ArcSDE geodatabases in Oracle databases

Print Previous page Top page Next page

To be able to access an ArcSDE geodatabase in an Oracle database the following conditions must be met:

  1. On a PC with GIS Panorama, a client set of libraries for accessing the Oracle DBMS - Oracle Call Interface (OCI) must be installed;
  2. Oracle database in which the base of geodata ArcSDE is placed must meet certain requirements:

- the database must support unicode;

- into Oracle database in which the base of geodata ArcSDE is placed, the library st_shapelib.dll with the stored procedures allowing external clients to address the spatial data in ArcSDE format must be added;

- to SDE user of the ArcSDE geodatabase, from which name a connection to the geodatabase from GIS Panorama will also be performed, necessary permissions should be assigned;

- to tables of geodatabase the triggers should be added, allowing to generate the new identifier for the records added by external clients;

- each table of a geodatabase with spatial data must have the required minimum of fields - an identifier of record and a field of spatial description (metrics) of object;

- tables with spatial data must be properly registered in the geodatabase and have an SRID coordinate system code corresponding to one of the EPSG codes;

- when using an SRID code that does not correspond to EPSG codes, this code must be correctly registered in the ArcSDE geodatabase and it must be possible to recalculate the metric with this SRID to the standard EPSG coordinate systems using the ArcSDE spatial extension at the SQL query level directly in the Oracle database.