论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2007-11-27 04:23 |只看该作者 |倒序浏览

oracle 10.2.0 (windows xp) 将一个大表数据export出来,34G, 文件直接export 到 USB 硬盘,再将此文件ftp 到 linux (Red hat AS4)机器上, 在 oracle 10.2 (Linux) 下导入,导入 60% 数据时候,报错:
Import: Release 10.2.0.1.0 - Production on Mi Nov 21 13:45:19 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.02.01 via conventional path
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
. importing TEST's objects into TEST
. . importing table                   "TEST"
illegal lob length marker 33238
bytesread = 00000000000
TABLE = TEST
IMP-00098: INTERNAL ERROR: impgst2
IMP-00018: partial impo‡'ælŠ¶Õ‰“’E³”ØÆ=ˆ^žƒ=ÿompleted: 144371 rows imported
IMP-00008: unrecognized statement in the export file:

IMP的语句:imp test/test tables="("test")" file=test.dmp IGNORE=Y commit=Y buffer=1000000000 log=test.log
exp 的LOG:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                      TEST
...........................................................................
...........................................................................
...........................................................................
....................................
                                                   261869 rows exported
Export terminated successfully without warnings.

TEST表包含LOB 数据:
Name                                     Null? Type
----------------------------------------- -------- ----------------------------
BBID_ID                                  NOT NULL NUMBER(19)
PATH                                              VARCHAR2(255 CHAR)
DATA                                              BLOB
DT_EXPIRATION                                     DATE
ID_RPK                                           NUMBER(19)

导出就一个表的数据, 一个文件,导入时的设置应该没错,不然也不会导进去60% 多的数据,DB 的 charset 也一致.

将此文件放到一个 10g (winxp )的DB 下去 IMP ,也是相同的错, 网上对 illegal lob length marker 33238
bytesread = 00000000000 说明很少,不知道确切原因.

请大家看看,有没遇到过,知道确切原因的? 如果是 EXP DUMP 文件有问题,LOG 却是成功无错的, 那以后做EXP 也不放心, 有没有检查DUMP文件有无错的方法?

文库|博客

managergh

富足长乐

论坛徽章:: 0

2楼 [报告]

发表于 2007-11-27 08:32 |只看该作者

帮你查了metalink 仿佛这个是BUG

Bug 号	5982984
已归档	10-APR-2007	已更新	27-JUN-2007
产品	Oracle Server - Enterprise Edition	产品版本	10.1.0.4
平台	Linux x86	平台版本	无数据
数据库版本	10.1.0.4	影响平台	Generic
优先级	Severe Loss of Service	状态	Closed, Could Not Reproduce
基本 Bug	N/A	修复产品版本	无数据

问题陈述:

IMPORT FAILS WITH IMP-00098: INTERNAL ERROR: IMPGST2
--------------------------------------------------------------------------------

*** 04/10/07 08:42 am *** TAR: ---- 17267186.6 / 6216116.993 . PROBLEM: -------- Import has the following errors: . . . importing table "WWUTL_APP_TX_MODULE_DETAILS$" illegal lob length marker 50432 bytesread = 00001269760 TABLE = WWUTL_APP_TX_MODULE_DETAILS$ IMP-00098: INTERNAL ERROR: impgst2 IMP-00028: partial import of previous table rolled back: 41 rows rolled back IMP-00008: unrecognized statement in the export file: ... . IMP-00008: unrecognized statement in the export file: Rel#04200 - Need to send updated star_portal.sps/.spb IMP-00032: SQL statement exceeded buffer length IMP-00008: unrecognized statement in the export file: from vg Z . Import terminated successfully with warnings. . Datapump is not an option, because this is a portal import/export. . DIAGNOSTIC ANALYSIS: -------------------- This same dump file has being uploaded in other databases without issues. Tried the following: . - Transfer the file again in binary format. Same results. IMP-00008 error. . - Transfer the dump file that returns IMP-8 error to a windows instance and import there. This works fine. . - Get the dump file from the csutoemr and imported in a local instance in support (SR 6216116.993) and this works fine. . Issue seems to be specific to that database as the same dump file can be imported fine in other instances as explained above. . WORKAROUND: ----------- Manually edit export file, and it works but this is a hardly ideal situation. . RELATED BUGS: ------------- . REPRODUCIBILITY: ---------------- Consistently on their platform. . TEST CASE: ---------- . STACK TRACE: ------------ Can get, if needed. . SUPPORTING INFORMATION: ----------------------- Uploading the .dmp file and related logs. RDA is available on the original SR if needed. . 24 HOUR CONTACT INFORMATION FOR P1 BUGS: ---------------------------------------- . DIAL-IN INFORMATION: -------------------- . IMPACT DATE: ------------ Immediate. . *** 04/10/07 08:51 am *** *** 04/10/07 08:51 am *** (CHG: Sta->16) *** 04/11/07 01:33 am *** (CHG: Asg->NEW OWNER) *** 04/11/07 01:33 am *** *** 04/11/07 03:18 am *** *** 04/11/07 04:38 am *** (CHG: Sta->10) *** 04/11/07 04:38 am *** *** 05/09/07 09:34 am *** (CHG: Sta->16) *** 05/09/07 09:34 am *** *** 05/28/07 02:50 am *** (CHG: Sta->11) *** 05/28/07 02:50 am *** *** 05/28/07 02:50 am *** (CHG: Asg->NEW OWNER) *** 05/28/07 02:50 am *** *** 05/31/07 11:52 pm *** (CHG: Asg->NEW OWNER) *** 06/18/07 12:03 am *** (CHG: DevPri->2) *** 06/18/07 12:03 am *** (CHG: Confirmed Flag->Y) *** 06/18/07 12:03 am *** (CHG: Asg->NEW OWNER) *** 06/26/07 10:05 pm *** (CHG: Sta->30) *** 06/26/07 10:05 pm *** *** 06/27/07 07:55 am *** (CHG: Sta->91) *** 06/27/07 07:55 am ***
.

[ 本帖最后由 managergh 于 2007-11-27 08:34 编辑 ]