How to Resolve ORA-39123 ORA-29339 Errors When Performing DataPump Transportable Tablespaces Import With Different Block Sizes (Doc ID 806284.1)

Last updated on JULY 03, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Jul-2013***

Goal

This note helps you in resolving ORA-39123 and ORA-29339 Errors when performing DataPump Transportable Tablespaces Import with different block sizes.

The error message ORA-29339 means, tablespace block size does not match configured block size,

The DataPump TTS import can fail with the following errors:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/******** parfile=test.par
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-29339: tablespace block size 32768 does not match configured block sizes

Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 10:43:33

 

Solution

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