EXPDP - ORA-39127 And ORA-00904 ("TRANS_NAME": Invalid Identifier) On MATERIALIZED_VIEW_LOG

(Doc ID 1571598.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a full database export job, the following error occurs.

Export: Release 11.2.0.3.0 - Production on Sun Jul 7 21:23:54 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_FULL_01":  /******** AS SYSDBA parfile=FULL_EXPDP_unofinP.par
Estimate in progress using BLOCKS method...
...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/MATERIALIZED_VIEW_LOG
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_TRANSFORM_EXIMP.INSTANCE_INFO_EXP('AQ$_AR_REV_REC_QT_S','AR',1,1,'11.02.00.03.00',newblock)
ORA-00904: "TRANS_NAME": invalid identifier
ORA-06512: at "SYS.DBMS_TRANSFORM_EXIMP", line 197
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 9081
...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
...
Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded

Identical errors were reported for:

APPLSYS.AQ$_WF_DEFERRED_TABLE_M_S
APPLSYS.AQ$_FND_CP_GSM_IPC_AQTBL_S
APPS.AQ$_UNO_ECX_OUTQTAB_S
AR.AQ$_AR_REV_REC_QT_S
ASG.AQ$_ASG_MTRAN_QTAB_S
ASG.AQ$_ASG_MTRAN_REP_QTAB_S
ASO.AQ$_ASO_ORDER_FEEDBACK_T_S
OKC.AQ$_OKC_AQ_EV_TAB_S
XNP.AQ$_XNP_OUT_MSG_QTAB_S

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