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 MAY 12, 2017

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.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.