A use of EXP data migration, the customer and I said lost the table, I feel more strange, the analysis log found Exp-00104:datatype (binary_double) error, the single table to export, found that the problem recurs
[oracle@app73 ~]$ exp system/oracle123 file=/data/1.dmp TABLES=CHF. T_xifenfei
Export:release 11.1.0.6.0-production on Wed Oct 14 23:25:31 2015
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:oracle Database 11g Enterprise Edition release 11.1.0.6.0-64bit Production
With the partitioning, OLAP, Data Mining and real application testing options
Export done in ZHS16GBK character set and Al16utf16 NCHAR character set
About to export specified tables via conventional Path ...
Current user changed to CHF
. . Exporting Table T_xifenfei
Exp-00104:datatype (binary_double) of column numcommissionrate in table
Chf. T_xifenfei is not supported, table won't is exported
Database version
Sql> select * from V$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition release 11.1.0.6.0-64bit Production
Pl/sql Release 11.1.0.6.0-production
CORE 11.1.0.6.0 Production
TNS for Linux:version 11.1.0.6.0-production
Nlsrtl Version 11.1.0.6.0-production
Table structure
Sql> DESC CHF. T_xifenfei
Name Null? Type
----------------------------------------- -------- ----------------------------
............
Numpro number
Numcommissionrate binary_double
Numseq binary_double
Nummark number
............
Solution, using EXPDP/IMPDP instead of Exp/imp
[oracle@app73 ~]$ EXPDP system/manager dumpfile=exp.dmp TABLES=CHF. T_xifenfei Directory=exp_dir
Export:release 11.1.0.6.0-64bit Production on Wednesday, October, 2015 23:30:38
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to:oracle Database 11g Enterprise Edition release 11.1.0.6.0-64bit Production
With the partitioning, OLAP, Data Mining and real application testing options
Starting "SYSTEM". " Sys_export_table_01 ": system/******** dumpfile=exp.dmp TABLES=CHF. T_xifenfei Directory=exp_dir
Estimate in progress using BLOCKS method ...
Processing Object Type Table_export/table/table_data
Total estimation using BLOCKS method:959 MB
Processing Object Type Table_export/table/table
Processing Object Type Table_export/table/index/index
Processing Object Type Table_export/table/constraint/constraint
Processing Object Type Table_export/table/index/statistics/index_statistics
Processing Object Type Table_export/table/comment
Processing Object Type Table_export/table/statistics/table_statistics
. . Exported "CHF". T_xifenfei "814.7 MB 1601202 rows
Master table "SYSTEM". " Sys_export_table_01 "Successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM. SYS_EXPORT_TABLE_01 is:
/tmp/exp.dmp
Job "SYSTEM". " Sys_export_table_01 "successfully completed at 23:31:31
[Oracle@app101-2 data]$ IMPDP system/oracle dumpfile=t_xifenfei.dmp TABLES=CHF. T_xifenfei Directory=exp_dir
Import:release 11.2.0.4.0-production on Wed Oct 14 23:44:35 2015
Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.
Connected to:oracle Database 11g Enterprise Edition release 11.2.0.4.0-64bit Production
With the partitioning and Data Mining options
Master table "SYSTEM". " Sys_import_table_01 "Successfully loaded/unloaded
Starting "SYSTEM". " Sys_import_table_01 ": system/******** dumpfile=t_xifenfei.dmp TABLES=CHF. T_xifenfei Directory=exp_dir
Processing Object Type Table_export/table/table
Processing Object Type Table_export/table/table_data
. . Imported "CHF". T_xifenfei "814.7 MB 1601202 rows
Processing Object Type Table_export/table/index/index
Processing Object Type Table_export/table/constraint/constraint
Processing Object Type Table_export/table/index/statistics/index_statistics
Processing Object Type Table_export/table/comment
Processing Object Type Table_export/table/statistics/table_statistics
Job "SYSTEM". " Sys_import_table_01 "successfully completed at Wed Oct 23:45:37 2015 elapsed 0 00:01:02
This type of error, but also related to their carelessness, did not carefully check the export log, and the issue from the 10.1.0.2, until now found that the lack of knowledge points. The same problem with Binary_float.
Specific reference: Export Failed Due to EXP-104 Error, Datatype (binary_double) are not supported [ID 421591.1]
Contact: Mobile Phone (13429648788) QQ (107644445) QQ Advisory Cherish Division fly
Title: http://www.xifenfei.com/2015/10/exp-00104-datatype-binary_double-error. html