Error During Import ORA-30951: Element Or Attribute At Xpath Active Exceeds Maximum Length (Doc ID 1556031.1)

Last updated on MAY 23, 2013

Applies to:

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

Symptoms

Error during import ORA-30951: Element or attribute at Xpath active exceeds maximum length

Import log shows:

Import: Release 11.2.0.3.0 - Production on Thu Jan 24 13:06:27 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Master table "EXPORTDB"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "EXPORTDB"."SYS_IMPORT_SCHEMA_01":  exportDB/******** schemas=HOMOLOGA directory=dmpdir dumpfile=HOMOLOGA.dmp
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "HOMOLOGA"."NOTRTZONE"                      1.491 MB   39977 rows
ORA-31693: Table data object "HOMOLOGA"."ALERTREPORT" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-30951: Element or attribute at Xpath active exceeds maximum length
. . imported "HOMOLOGA"."COMPDICT"                       726.2 KB   22709 rows

......

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Job "EXPORTDB"."SYS_IMPORT_SCHEMA_01" completed with 1 error(s) at 13:16:41

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