My Oracle Support Banner

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

Last updated on MARCH 10, 2020

Applies to:

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


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


NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


Using syntax like the following to plug in some schemas:

impdp user/pass ..

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

 - 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


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


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

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