Export Error ORA-01722: Invalid Number During Transportable Tablespaces Option (Doc ID 728923.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3.0
This problem can occur on any platform.

Symptoms

Running export using Transportable Tablespaces get the following error.

EXP-00008: ORACLE error 1722 encountered
ORA-01722: invalid number


Export Log:

table MM_RFA_ELEMENTS_JN
. . exporting table MMPM_DEAL_SEARCHES_JN
EXP-00008: ORACLE error 1722 encountered
ORA-01722: invalid number
. . exporting table MM_PRT_SUBS_REDS_ADJS_JN
For tablespace AUDIT_INDEX ...
. exporting cluster definitions
. exporting table definitions
. . exporting table CDB_INSTRUMENT_GROUPINGS_JN
For tablespace GFAS_DATA1 ...

Changes

Table contains XMLTYPE columns.

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