Overview

You may notice that text fields have different DATA_TYPE (field type) on the database level such as NCLOB and NVARCHAR2 in the example below.

This article explains the reason why there are different field types present in the database and if this behavior can be changed.

Information

Why does this happen?

These different data types are a result of the field length change although there are a small few DB fields that will have these field types by default. Moreover, the NVARCHAR datatype can even be changed to NVARCHAR(1024) or NVARCHAR(MAX) to extend the field length.

As for the NCLOB datatype, please note these are used to store large blocks of character data from the National Character Set, which can also be a consequence of the field length change in text fields.

Can this behavior be changed?

This change is not done by the Oracle database itself. Instead, it's triggered and performed by ACRM modules However, there is currently no way to customize/control this behavior when changing the field length. If you would like to have control/customization of the datatype changes in ACRM, you can submit a Feature Enhancement Request.