Transportable Tablespace Export Reporting Internal Error [Database Id] [0] from Dbms_plugts (Doc ID 1369849.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.0 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

TTS Datapump export fails with the following errors:

EXP-00008: ORACLE error 29336 encountered
ORA-29336: Internal error [database ID] [0] from DBMS_PLUGTS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_PLUGTS", line 756
ORA-06512: at "SYS.DBMS_PLUGTS", line 1109
ORA-06512: at "SYS.DBMS_PLUGTS", line 1334
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully


exp file being used includes following parameters:


userid="/ as sysdba"
file=TTS_META_PNYPGL30.dmp
log=exp_PNYPGL30_tts_meta.log
transport_Tablespace=y
tablespaces=TBS1, TBS2...

Changes

This database was upgraded from 10.2.0.2 using rman clone and catupgrd script.
All components have valid status:

COMP_NAME                                        VERSION            STATUS
------------------------------                    --------------------   ---------------------
Oracle Database Catalog Views            11.2.0.2.0               VALID
Oracle Database Packages and Types   11.2.0.2.0               VALID

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