To Import From Oracle

You can import data from a connected Oracle database into your map. Using this option, your data will be imported as drawing objects. The data will be a snapshot of your Oracle data.

To import data from an Oracle data source

  1. In Display Manager , click DataConnect To Data.

    For more information, see To Bring In Features from Oracle.

    Note: Follow the steps through clicking Connect, then stop. Do not add the features to your map.
  2. At the Command prompt, enter mapimportfdo.
  3. In the Map Import From FDO dialog box, select the Oracle data source connection from which to import data.
  4. Click OK.
  5. In the Import dialog box, review the Current Drawing Coordinate System to make sure it is correct.
  6. Under Spatial Filter, specify whether to limit the area where data will be imported:
    • None — Place no area limits on the incoming file.
    • Current Display — Limit the import to the current drawing area.
    • Define Window — Limit the import to an area you define. To use this option, click Select. Respond to the prompts to define the area.
  7. Specify the import settings for each input layer (see the Import dialog box for details).
    • Drawing Layer— Select a target layer for each layer in the incoming file.
    • Object Class— Assign incoming objects to an existing object class and map incoming attribute data to the data fields in the object class. The Object Class fields are available only if you have object classes defined in your map.
    • Input Coordinate System— Specify the coordinate system of the incoming file. If the drawing has a coordinate system assigned to it, incoming objects are converted to the coordinate system of the drawing.
    • Data— For each layer, specify how to import data.
    • Points— For each layer, specify how to treat incoming point objects.
  8. By default, polygons are imported as polygon objects. To import them as closed polylines, select Import Polygons As Closed Polylines.
  9. Click OK to begin the import process.