Creation of the geo database ArcSDE in DB Oracle

 Print Previous page Top page Next page

Creation of a geo database in the database Oracle is performed using the program ArcMap. To do this, you need to start the program ArcMap and to call the dialog «Create enterprise geodatabase» in it. You can call up this dialog using the search operation: press «Ctrl + F» and in the search form type «Create enterprise geodatabase», then in the search results select the item «Create enterprise geodatabase (Data Management) (Tool)».

 

In the dialog for creating a geo database, enter the connection parameters from the superuser SYS to the database Oracle where the geo database will be located, enter the name of the administrator of the geo database – SDE, set the password for it, and specify the authorization file ArcGIS. Additionally, you can specify a table space if you want to store geo database tables in a separate table space.

 

If all the parameters are correctly filled, then clicking on the button «OK» will connect to the database Oracle, creating SDE schema in it and adding a geo database in this scheme. The status window of the process for creating a geo database will inform about the progress.

 

The created geo database does not have a structure for storing the layers of DTM.

Depending on how you plan to continue to use the geo database, one of the following is true:

-  if you need to restore the geo database to a database Oracle that was previously exported from another storage format, you import the file XML into which the source geo database was exported;

-  if you need to create a geo database structure in the database Oracle for later filling it with data during the export of layers of DTM from the format GIS Panorama, it is imported the file XML, containing the description scheme of the geo database structure.

 

Both processes are no different from each other. The difference is only in the imported XML file and whether the data load is being imported or only when creating a geo database structure.

Below, it will consider the process of creating a structure of the geo database in the database Oracle for the subsequent loading of DTM layers for the scale 1: 25 000, exported from the format GIS Panorama. To do this, it will use a file with a scheme describing the structure of the geo database 25K_SCHEMA.XML.

Operations to create geo databases in the database Oracle for scales 1: 50,000 and 1: 100,000 are performed in full analogy. For them, files with schemes describing the structures of geo databases 50K_SCHEMA.XML and 100K_SCHEMA.XML, respectively, are applied.

In the catalog ArcGIS, create a new connection to the database Oracle in which the geo database was created. It is necessary to perform the connection as SDE user.

 

After creation, a new connection appears in the tree in the section Database Connections.

Importing file XML for this connection is started from the context menu, which is called by right-clicking on this connection in the tree ArcGIS Catalog. In the context menu select Import – XML Workspace Document.

 

In the dialog that appears, import the document XML, it is necessary to specify the path to the imported file and the import mode. The import mode depends on whether you are loading data or just creating a geo database structure. To create a structure without importing data, select «Schema Only».

Clicking the button «Next» will display the contents of the selected XML file.

Clicking the button «Finish» will start the import process. The progress and the status of its completion will be reflected on the screen in the corresponding window.