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

Last updated on SEPTEMBER 07, 2021

Applies to:

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
Primary table "EXPORTDB"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "EXPORTDB"."SYS_IMPORT_SCHEMA_01":  exportDB/******** schemas=<SCHEMA_NAME> directory=<DIR> dumpfile=<FILE_NAME>.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 "<SCHEMA_NAME>"."<TABLE_NAME>"                      1.491 MB   39977 rows
ORA-31693: Table data object "<SCHEMA_NAME>"."<TABLE_NAME>" 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 "<SCHEMA_NAME>"."<TABLE_NAME>"                       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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.