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:
This problem can occur on any platform.


Running export using Transportable Tablespaces get the following error.

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

Export Log:

. . 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
For tablespace GFAS_DATA1 ...


Table contains XMLTYPE columns.


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

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.