Importing From Oracle
Concept Procedure Quick Reference
 
 
 

To import date from an Oracle data source

  1. Before moving Oracle data into your map, assign a coordinate system to the map. This lets you position your data accurately in a real-world geographic location and align imported survey or GPS point data.
  2. In Display Manager, click DataConnect To Data.

    For more information, see Bringing In Features from Oracle

    NoteFollow the steps through clicking Connect, then stop. Do not add the features to your map.
  3. At the Command prompt, enter mapimportfdo.
  4. In the Map Import From FDO dialog box, select the Oracle data source connection from which to import data.
  5. Click OK.
  6. In the Import dialog box, review the Current Drawing Coordinate System to make sure it is correct.
  7. 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.
  8. Specify the import settings for each input layer:
    • 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 drawing. For more information about setting up object classes, see Setting Up Object Classification.
    • Input Coordinate System— Specify the coordinate system of the incoming file. If the AutoCAD Map 3D 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.
    Note If you are importing points and have assigned them to an object class with a creation method of Blocks, you must use the Points column to convert the points to blocks so that the objects can be classified. Object classification does not convert points to blocks for you.
  9. By default, polygons are imported as polygon objects. To import them as closed polylines, select Import Polygons As Closed Polylines.
  10. If you assigned incoming objects to object classes and want to use the object class defaults for any incoming data that is out of the defined object class range, select Use Class Defaults For Out Of Range Values.

    If you do not select this option, incoming data will be imported as is, which may include some out of range values. If you later view the data on the Object Class tab of the Properties palette, AutoCAD Map 3D automatically modifies the data, using defaults as needed, so that the data is in range and properly classified.

  11. To save your settings as a profile, click Save. These saved profiles can be loaded when you import other files, and they can be used to automate command-line scripts.
  12. Click OK to begin the import process.

    If you cancel the import operation, all objects imported prior to canceling will remain in the AutoCAD Map 3D drawing. You can delete these objects and any associated data.