ORA-12899 While Importing Portal Schema into a Metadata Repository Database (Doc ID 351752.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]
Portal - Version 10.1.2.0.2 to 11.1.1.5.0 [Release 10gR2 to FMW11g]
Information in this document applies to any platform.
Checked for relevance on 03-Mar-2015

Symptoms

When importing a Portal schema into a new metadata repository database, and error may occur :

IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "PORTAL"."WWNLS_STRINGS$"."TEXT_START" (actual: 268, maximum: 256)
. . importing table "WWWCP_URL_PARAMETER$" 0 rows imported
IMP-00041: Warning: object created with compilation warnings

Changes

The Database character sets on the target database is different from the character set from the source database.

Cause

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