My Oracle Support Banner

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

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
  Changes
  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.