My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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.