My Oracle Support Banner

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

Last updated on AUGUST 02, 2019

Applies to:

Oracle WebCenter Content - 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.