ERROR EXP-00104: datatype (BINARY_DOUBLE) of column is not supported

If you get the error ERROR EXP-00104: datatype (BINARY_DOUBLE) of column is not supported, table will not be exported

than solution is to use DataPump Export (expdp) instead of conventional Export (exp).

As per the Metalink Doc ID: 421591.1

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later   [Release: 10.1 and later ]
Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later    [Release: 10.1 and later]
Information in this document applies to any platform.
***Checked for relevance on 23-SEP-2011***

Goal

How to resolve an EXP-104 error?

...
About to export specified tables via Conventional Path ...
. . exporting table TEST_BINARY_FLOAT
EXP-00104: datatype (BINARY_FLOAT) of column BF in table SYSTEM.TEST_BINARY_FLOAT is not supported, table will not be exported
Export terminated successfully with warnings.

Solution

Use DataPump Export (expdp) instead of conventional Export (exp).

The next small test case will demonstrate this:

1.  Create the test table with a binary_float column.

SQL> connect system/password
SQL> create table test_binary_float (bf binary_float);
SQL> insert into test_binary_float values(12345);
SQL> commit;

2.  Conventional Export (exp) will fail with EXP-104 error, since the datatype BINARY_FLOAT is not supported.

#> exp system/password file=exp.dmp tables=test_binary_float

Export: Release 10.2.0.2.0 - Production on Thu Mar 29 09:56:42 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table TEST_BINARY_FLOAT
EXP-00104: datatype (BINARY_FLOAT) of column BF in table SYSTEM.TEST_BINARY_FLOAT is not supported, table will not be exported
Export terminated successfully with warnings.

3.  Data Pump Export (expdp) will succeed, since the datatype BINARY_FLOAT is supported.

#> expdp system/password dumpfile=exp.dmp tables=test_binary_float

Export: Release 10.2.0.2.0 - Production on Thursday, 29 March, 2007 9:59:30
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/******** dumpfile=exp.dmp tables=test_binary_float
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SYSTEM"."TEST_BINARY_FLOAT" 4.937 KB 1 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
D:\ORACLE\ADMIN\OASM\DPDUMP\EXP.DMP
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 09:59:59