View Oracle spatial tables with multiple geometry fields using Data Interoperability extension

Summary

Instructions provided describe how to view an Oracle spatial table containing multiple geometry fields in ArcGIS using the Data Interoperability extension.

Procedure

1. In ArcCatalog, double-click on Add Interoperability Connection in the catalog tree.
   
   Click on the ellipses button (...) next to the Format dropdown list.
   
   
2. At the bottom of the window under Custom Formats, click on New...
   
   Follow the steps through the wizard that displays.
   
   
3. In the second page of the wizard, select Oracle 10g/9i/8i Spatial (Object) as the source format. Click Next.
   
   
4. Click on Settings. Input the connection properties for the Oracle Database.
   
   Under Constraints, click the ellipses button (...)
   
   Select the table containing the data. Click OK twice; click Next.
   
   

   Note:
   
   To expose the parameters, select them now; otherwise click Next.

5. Give the custom format a name and description and click Next, then Finish.
6. After clicking Finish in the wizard, FME Workbench opens. Specify the MDSYS.SDO_GEOMETRY field.
   
   In the Workbench Canvas > Properties, right-click on the source data.
   
   Click on the Parameters tab.
   
   Type the name of the MDSYS.SDO_GEOMETRY field.
   
   Click OK.
7. Save the custom format in Workbench by clicking on File > Save. Close Workbench.
8. In the Formats Gallery window select the new format just created. Click OK.
9. In the Interoperability Connections window, click OK.
   
   A new connection is created in the catalog tree. Open the connection to Preview the spatial information in ArcCatalog or add it to ArcMap.
   
   

   Note:
   The first time the spatial data is viewed, ArcGIS indexes the features.