Skip to main content

Migrate Text Field (Data Management Tools)

Summary

Migrates text fields in an Oracle table from Unicode to non-Unicode types.

Usage

  • This tool does not run on traditional versioned datasets.

  • The input must be from an enterprise geodatabase in Oracle.

  • This tool will convert text field types as follows.

    • NVARCHAR2 will be converted to VARCHAR2.

    • NCLOB will be converted to CLOB.

    • NCHAR will be converted to VARCHAR2.

Parameters

Label Explanation Data type

Input Table

The Oracle dataset from which eligible text fields will be migrated.

Table View

Fields

The Unicode text fields that will be migrated to non-Unicode text fields.

Field

Derived output

Label Explanation Data type

Updated Table

The updated table.

Table View

Environments

This tool does not use any geoprocessing environments.

Licensing information

  • Basic: No
  • Standard: Yes
  • Advanced: Yes