My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


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.