ORA-12899 Using Datapump Import With Transporting Tablespaces (TTS) Having Multiple Schemas or Tablespaces (Doc ID 727997.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 28-JAN-2010***
***Checked for relevance on 16-JAN-2011***

REMAP_SCHEMA= ..
REMAP_TABLESPACE= ..

TTS of multiple tablespace or schema may encounter the same problem, we will consider on this article plugging multiple schema as example.


Symptoms

Using syntax like the following to plug in some schemas:

impdp user/pass ..
REMAP_SCHEMA='ORG_SCHEMA_1:TARGET_SCHEMA_1,ORG_SCHEMA_2:TARGET_SCHEMA_2,ORG_SCHEMA_3:TARGET_SCHEMA_3, ..,ORG_SCHEMA_n:TARGET_SCHEMA_n' ...


Once starting plugging TTS you get the following errors
 - Import log reports following error stack:

Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
ORA-39097: Data Pump job encountered unexpected error -12899
ORA-39065: unexpected master process exception in DISPATCH
ORA-12899: value too large for column "SYS"."SYS_IMPORT_TRANSPORTABLE_01"."OBJECT_SCHEMA" (actual: 130, maximum: 30)
ORA-39014: One or more workers have prematurely exited.
ORA-39014: One or more workers have prematurely exited.


 - Alert.log reports error like the following

The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=23, OS id=2842
to execute - SYS.KUPM$MCP.MAIN('SYS_IMPORT_TRANSPORTABLE_01', 'SYS', 'KUPC$C_1_20080527141502', 'KUPC$S_1_20080527141502', 0);
kupprdp: worker process DW01 started with worker id=1, pid=24, OS id=2849
to execute - SYS.KUPW$WORKER.MAIN('SYS_IMPORT_TRANSPORTABLE_01', 'SYS');


 - JOB Dump reports error like the following

*** ACTION NAME:(SYS_IMPORT_TRANSPORTABLE_01) 2008-05-27 14:10:02.576
*** MODULE NAME:(Data Pump Worker) 2008-05-27 14:10:02.576
*** SERVICE NAME:(SYS$USERS) 2008-05-27 14:10:02.576
*** SESSION ID:(91.362) 2008-05-27 14:10:02.576
ORA-39123: Data Pump transportable tablespace job aborted
ORA-06502: PL/SQL: numeric or value error: character string buffer too small kwqaadqrs: error 39119 during add rule

Changes

Importing single schema/tablespace with typical syntax done successfully, when adding more schemas/tablespaces we get the reported errors.

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