To Bring In Features from Oracle

You can bring features from an Oracle data source into your map, creating a feature layer in Display Manager.

Bring in features from Oracle

1. Make sure that your feature source is set up correctly.
2. In Display Manager, click DataConnect To Data.
3. In the Data Connect window, select Add Oracle Connection in the Data Connections By Provider list.
4. In the Feature Source Connection dialog box, under Connection Name, type a name for this connection.
5. Under Service Name, enter the service name for the Oracle data store. If you do not know this name, check with your System Administrator.
6. Click Login.
7. In the User Credentials dialog box, enter your Oracle user name and password.

   Optionally, select Remember Password if you want AutoCAD Map 3D toolset to log you in whenever you open this drawing.

8. Under Data Store, enter the data store name. If you do not know this name, check with your System Administrator.

   To select from a list of data stores, click the down arrow.

   Note: If the data store is not in the list, it may not use a AutoCAD Map 3D toolset schema. Select Show All Data Stores to add these to the list. AutoCAD Map 3D toolset creates a mapping to use these data stores.
9. Optionally, select a version of the data store.
10. Click Connect.
11. In the feature class list, select the feature classes to include in the map.

    If this feature source contains only a single feature class, that feature class is selected automatically. If it contains multiple feature classes, you can do either of the following:

    • Right-click the schema entry and select Select All or Select None.
    • Expand the schema entry and select the feature classes to add.

      If a feature class contains multiple geometry types,and you select the feature class itself, all geometries are added. To add a subset of geometries, hold your cursor over the feature class name to see the Show Geometry button. Click Show Geometry to see each geometry as a separate choice. Select the ones you want. Each selected geometry is added to map as a separate Display Manager layer.

12. Verify that the coordinate systems are correct. You can change an incorrect coordinate system if necessary.
13. Click Add To Map.

    To bring in a subset of the data, click the down arrow and select Add To Map With Query, where the properties for all geometries appear. To filter data after you’ve added the data to your map, see To Filter Feature Layers.

Access FDO Data Stores Created in AutoCAD Map 3D 2007 and Earlier Releases

1. Verify that you have the privileges required to execute the ALTER TABLE request.
2. In the command line, enter the following:

   sqlplus <datastorename>/<yourpassword>@<tnsServiceName>

   @<MapInstallDir>/Fdo/bin/com/AlterSchemaOracle.sql;

   exit;