What Datatype Can Be Used to Store 10,000 Characters For a Metadata Field? (Doc ID 761377.1)

Last updated on JUNE 02, 2017

Applies to:

Oracle Universal Content Management - Version: 7.5.2 to 10.1.3.3.3 - Release: Stellent to 10gR3
Information in this document applies to any platform.

Goal

You have an Oracle database with unicode encoding. All text fields are of the datatype NVARCHAR2.  You want to add a new field to the system and define it as a memo type but with a size of 10,000 instead of 1024. You can update the admin server configuration to have MemoFieldSize=10000, however you cannot change the field definition in the database since the NVARCHAR2 type does not expand past 2000 characters.  What datatype can you use?



Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms