Migrate Text Field (Data Management)

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

Dialog

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

Python

arcpy.management.MigrateTextField(in_table, fields)

Name	Explanation	Data Type
in_table	The Oracle dataset from which eligible text fields will be migrated.	Table View
fields [fields,...]	The Unicode text fields that will be migrated to non-Unicode text fields.	Field

Derived Output

Name	Explanation	Data Type
out_table	The updated table.	Table View

Code sample

MigrateTextField example (Python window)

The following Python window script demonstrates how to use the MigrateTextField function.

import arcpy
arcpy.management.MigrateTextField(
    in_table=r"C:\path\to\project\Default.gdb\FeatureClass",
    fields=["Field_text", "Field_text_II"])

Environments

This tool does not use any geoprocessing environments.

Licensing information

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