Arcgis Access Oracle Spatial data __oracle

1. Execute the following SQL command via Sqlplus

Sql>colcomp_name format A10;

Sql>selectcomp_name,status from Dba_registry where comp_name= ' Spatial ';

If the result type is the following, the installation is successful (the status is valid or loaded is OK)

2. The version of spatial installation can be checked by the following command

sql> Select Sdo_versionfrom Dual;

3. General process Shpfile Import oraclespatial

² using the Shp2sdo.exe and Oracle built-in tools (Sqlplus and Sqlldr), download the SHP2SDO tool address as follows:

Http://www.oracle.com/technology/software/products/spatial/files/shp2sdo.zip

Run Shp2sdo.exe

4. According to the prompt input, mainly the first two, to import the Shpfile file location and export file location, generate. sql,. ctl, and. Dat three files, and the resulting files and Shp2sdo.exe are in the same directory.

5. Execute the. sql file generated by the step through SQL Plus, the following command for reference

6. Upload data to the space table created in the previous step, the following command for reference

Sqlldruserid=prod/prod control=c: \city.ctl data=c: \city.dat

7. Finally create the space index, the following command for reference

CreateIndex idx_tablename on TableName (geometry_cloumname) Indextype Ismdsys.spatial_index;

8. Finally, the query function provided by arcmap10.0 can see the imported spatial data