Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in UTF8 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user READER_0329
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user READER_0329
About to export READER_0329's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export READER_0329's tables via Direct Path ...
. . exporting table AP_LOGS 16 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table AP_MOBILE_AGENDA 43 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table AP_MOBILE_APPLICATION 3 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfullyOracle
2如果有,删除表上的物化视图日志后,在exp导出
导出:
C:\Users\**>exp 'user/pwd@db as sysdba' file=**\*.dmp log = **\*.log statistics=none导入:
C:\Users\**>imp 'user/pwd@db as sysdba' file=**\*.dmp log = **\*.log
希望能帮到你