Data Model: Oracle Schema Converter

Autodesk provides a schema converter that converts any Oracle structure into an enterprise industry model schema. For example, use the schema converter to convert an Oracle table in an enterprise industry model feature class. In the first step, the schema converter analyzes all non industry model tables, and lists any conflicts. After resolving the conflicts, the tables are ready to be converted. The conversion adds industry model specific columns, renames the geometry column to GEOM, creates and stores the industry model metadata.

To analyze and convert an Oracle schema

1. Start Infrastructure Administrator .
2. Create a project .
3. Under Industry Models, click Import.
4. Do one of the following.
   • Select Import From Existing Oracle Schema. In the Add Existing Schema dialog box, clear Show Only Enterprise Industry Model Schemas. Select the schema. Enter the password.
   • Select Import From Oracle Dump File. Select the dump file. Specify the settings. Enter the password.
5. If you select a non-enterprise industry model schema, or a non-enterprise industry model dump file, you are prompted whether to create an enterprise industry model structure, and to open the Converter now. Click Yes.
6. In the Create New Industry Model dialog box, under Extensions, check the Extensions, and under Spatial, check the SRID. Click OK.

Note:

The enterprise industry model supports only one SRID per industry model. When you create a new industry model to import a non-enterprise industry model schema, make sure that you specify the SRID in the Industry Model Settings - Spatial. Then, the schema converter will convert all tables that match the industry model’s SRID.

The non-enterprise industry model schema is analyzed, and the results are displayed in the Convert To Industry Model Schema dialog box. Use the settings as shown in the following table.

Convert To Industry Model Schema	Description
Tables	Displays the analysis results. Use the data grid to filter for tables where a conflict has been detected.
Analyze And Convert	Analyses and Converts the Oracle schema.
Analyze	Analyzes the data structure. If you have resolved any conflict, click Analyze to restart the analysis. You can start the analysis as often as needed.
Convert	Starts the conversion. See also Converting Oracle Tables.
Display	Selects whether to show all tables in the data grid, or tables with conflicts only.
data grid	Displays the results of the analysis. Click a row, to display more details in the right pane.
Table Name	Displays the table name.
State	Displays the result. Ready = Table can be converted. Resolve Conflicts = Table cannot be converted. Conflicts must be resolved.
State Description	Displays the analysis details of the selected table. Select a row, and use the options in the right pane to resolve simple conflicts, or use any Oracle tool to resolve other conflicts. If appropriate, select multiple rows to resolve the conflicts.
Table Name	Displays the table name. If the table name has more than 25 characters, enter a shorter table name.
Table Type	Specifies the table type to resolve the following simple conflicts. Table has no geometry column Do not Convert. Convert To Attribute Feature Class. Convert to Domain Table. Table has a geometry column, but the geometry type cannot be determined Attribute Point Line Polygon Collection
Primary Geometry Column	For feature classes that have multiple GEOM columns, selects the primary geometry column.

When you have resolved the conflicts, you start the conversion of the tables that have the state Ready.

To convert the schema

1. In the Convert To Industry Model Schema dialog box, click Convert.
2. The data grid displays the converted tables, and the State. The State can either be Conversion Succeeded, Resolve Conflicts, or Conversion Errors.

For a Conversion Error, the right pane shows more details. Use any Oracle tool to resolve the errors, and start the analysis and the conversion again.

Note:

To analyze and convert single Oracle tables that are part of an enterprise industry model , start the schema analysis in the industry model. In the data model explorer, right-click the industry model node and click Convert Tables To Feature Classes.

For more information, see Oracle Spatial Users Guide and Reference.