SCHEMA EXPORT
************************************
[oracle@Linux03 dpump]$ exp pdborcl1_usr2/XXXXXXXXXX@pdborcl1 file=/u01/app/oracle/dpump/exp_test.dmp log=/u01/app/oracle/dpump/exp_test.log
Export: Release 12.1.0.2.0 - Production on Wed Mar 23 09:02:30 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user PDBORCL1_USR2
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user PDBORCL1_USR2
About to export PDBORCL1_USR2's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export PDBORCL1_USR2's tables via Conventional Path ...
. . exporting table TEST 1 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TEST_ID 2 rows exported
EXP-00056: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
.
.
.
.
.
. exporting statistics
Export terminated successfully with warnings.
************************************
EXPORT TABLE :
************************************
[oracle@Linux03 dpump]$ exp pdborcl1_usr2/XXXXXXXX@pdborcl1 file=/u01/app/oracle/dpump/exp_test.dmp log=/u01/app/oracle/dpump/exp_test.log tables=PDBORCL1_USR2.TEST
Export: Release 12.1.0.2.0 - Production on Wed Mar 23 09:25:04 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table TEST 1 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
any solution on this?
ReplyDeleteI also meet this problem now
yuu should use the
ReplyDeletestatistics=none
parameter.