利用import导入数据时,导到一张大表时(该大表保存的是图片文件,BLOB字段)不成功,不知道是啥原因,请高手们帮忙看看。
环境:red hat linux enterprise as 3 ,oracle 10g,pcserver
从另外一台LINUX机器EXP出来一个DMP,再把该DMP文件(40g)导到另外一台linux 上去时报错
报错如下:
IMP-00009: abnormal end of export file
IMP-00027: failed to rollback partial import of previous table
IMP-00003: ORACLE error 24909 encountered
ORA-24909: call in progress. Current operation cancelled
IMP-00000: Import terminated unsuccessfully
操作过程如下:
SQL> host
[oracle@localhost Winxt]$ imp system/manager@rheas3 file=/mnt/imp_data/bysj.dmp fromuser=bysj touser=bysj ignore=y
Import: Release 10.2.0.1.0 - Production on Wed Apr 11 13:05:12 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.01.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
. importing BYSJ's objects into BYSJ
. . importing table "BYSJ_DATA_SESDD" 5066 rows imported
. . importing table "BYSJ_DATA_GESD" 173 rows imported
. . importing table "BYSJ_DATA_SEGD" 0 rows imported
. . importing table "BYSJ_DATA_ASJD" 0 rows imported
. . importing table "BYSJ_DATA_GES" 0 rows imported
. . importing table "BYSJ_DATA_GET" 3598 rows imported
. . importing table "BYSJ_DATA_EEWS" 0 rows imported
. . importing table "BYSJ_DATA_GEDD" 31564 rows imported
. . importing table "BYSJ_DATA_EGWEREFDD" 304 rows imported
. . importing table "BYSJ_DATA_RERASDD" 4 rows imported
. . importing table "BYSJ_DATA_GERERA" 0 rows imported
. . importing table "BYSJ_DATA_AF" 2011 rows imported
. . importing table "BYSJ_DATA_REDL" 0 rows imported
. . importing table "BYSJ_DATA_FVDF" 0 rows imported
. . importing table "BYSJ_DATA_GERBFD" 12 rows imported
. . importing table "BYSJ_DATA_GAHJ" 1241 rows imported
. . importing table "BYSJ_DATA_FRFR" 3152 rows imported
. . importing table "BYSJ_DATA_REYT" 0 rows imported
. . importing table "BYSJ_DATA_GCJL_WCS" 2871 rows imported
. . importing table "BYSJ_DATA_GEFSERK" 0 rows imported
. . importing table "BYSJ_DATA_ERED" 71973 rows imported
. . importing table "BYSJ_DATA_FER" 11356 rows imported
. . importing table "BYSJ_DATA_GERE" 0 rows imported
. . importing table "BYSJ_DATA_HRTK" 173 rows imp
. . importing table "BYSJ_DATA_QKKKJK" 2514 rows imp
. . importing table "BYSJ_DATA_HRT" 132249 rows imp
. . importing table "BYSJ_DATA_HRTSGGGF" 3126 rows imp
. . importing table "BYSJ_DATA_KLGHDGH" 0 rows imp
. . importing table "BYSJ_DATA_EUYTT" 994 rows imp
. . importing table "BYSJ_DATA_YTEVVV" 54 rows imp
. . importing table "BYSJ_DATA_JKMNB" 2 rows imp
. . importing table "BYSJ_DATA_ZBEHN" 2 rows imp
. . importing table "BYSJ_DATA_AREC" 87546 rows imp
. . importing table "BYSJ_DATA_MXDC" 35004 rows imp
. . importing table "BYSJ_DATA_FQER" 0 rows imp
. . importing table "BYSJ_DATA_WQIL" 17631 rows imp
. . importing table "BYSJ_DATA_OPKL" 79 rows imp
. . importing table "BYSJ_DATA_LOA" 883 rows imp
. . importing table "BYSJ_DATA_LZFE" 491440 rows imp
. . importing table "BYSJ_DATA_ADFER" 3300 rows imp
. . importing table "BYSJ_DATA_AEER"
IMP-00009: abnormal end of export file
IMP-00027: failed to rollback partial import of previous table
IMP-00003: ORACLE error 24909 encountered
ORA-24909: call in progress. Current operation cancelled
IMP-00000: Import terminated unsuccessfully
[oracle@localhost Winxt]$ EXIT
bash: EXIT: command not found
警告日志如下:
Wed Apr 11 13:10:08 2007
Thread 1 cannot allocate new log, sequence 121
Checkpoint not complete
Current log# 2 seq# 120 mem# 0: /u01/app/oracle/oradata/rheas3/redo02.log
Thread 1 advanced to log sequence 121
Current log# 3 seq# 121 mem# 0: /u01/app/oracle/oradata/rheas3/redo03.log
Wed Apr 11 13:10:35 2007
Thread 1 advanced to log sequence 122
Current log# 1 seq# 122 mem# 0: /u01/app/oracle/oradata/rheas3/redo01.log
Wed Apr 11 13:11:02 2007
Thread 1 cannot allocate new log, sequence 123
Checkpoint not complete
Current log# 1 seq# 122 mem# 0: /u01/app/oracle/oradata/rheas3/redo01.log
Thread 1 advanced to log sequence 123
Current log# 2 seq# 123 mem# 0: /u01/app/oracle/oradata/rheas3/redo02.log
Wed Apr 11 13:11:28 2007
Thread 1 cannot allocate new log, sequence 124
Checkpoint not complete
Current log# 2 seq# 123 mem# 0: /u01/app/oracle/oradata/rheas3/redo02.log
Thread 1 advanced to log sequence 124
Current log# 3 seq# 124 mem# 0: /u01/app/oracle/oradata/rheas3/redo03.log
Wed Apr 11 13:11:53 2007
Thread 1 cannot allocate new log, sequence 125
Checkpoint not complete
Current log# 3 seq# 124 mem# 0: /u01/app/oracle/oradata/rheas3/redo03.log
Thread 1 advanced to log sequence 125
Current log# 1 seq# 125 mem# 0: /u01/app/oracle/oradata/rheas3/redo01.log
Wed Apr 11 13:12:20 2007
Thread 1 cannot allocate new log, sequence 126
Checkpoint not complete
Current log# 1 seq# 125 mem# 0: /u01/app/oracle/oradata/rheas3/redo01.log
Thread 1 advanced to log sequence 126
Current log# 2 seq# 126 mem# 0: /u01/app/oracle/oradata/rheas3/redo02.log
Wed Apr 11 15:10:06 2007
Thread 1 advanced to log sequence 127
Current log# 3 seq# 127 mem# 0: /u01/app/oracle/oradata/rheas3/redo03.log