Expdp And Impdp Fail With ORA-31693 LPX-210 ORA-6512 (Doc ID 1374843.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 15-Apr-2013***

Symptoms

11.2 EXPDP and IMPDP fail to export (respectively import) a table named <table_owner>.<table_name> and raise the following bunch of errors:

ORA-31693: Table data object "<table_owner>"."<table_name>" failed to load/unload and is being skipped due to error:
ORA-06502: PL/SQL: numeric or value error
LPX-00210: expected '<' instead of '


Description of the table shows existence of a column of type XMLTYPE

SQL> desc <table_owner>.<table_name>;
Name Null? Type
----------------------------------------- -------- ----------------------------
...
<column_name> XMLTYPE


All your attempts to get the SQL DDL command of this table by calling dbms_metadata.get_ddl() fail with nearly the same bunch of errors.

SQL> set long 50000
SQL> select dbms_metadata.get_ddl('TABLE','<table_name>','<table_owner>') from dual;
ERROR:
ORA-06502: PL/SQL: numeric or value error
LPX-00210: expected '<' instead of '
ORA-06512: at "SYS.DBMS_METADATA", line 4018
ORA-06512: at "SYS.DBMS_METADATA", line 5843
ORA-06512: at line 1

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