Re: redhat 7.3 oracle 9.2 import problem

Tom <tomNOSPAM_at_teameazyriders.com> schreef in berichtnieuws 2MAVa.3451$rt3.31796453_at_news-text.cableinet.net...
| Hi,
|
| on the above system i'm trying to import a dump of a user that is from a
| 8.1.5 system
|
| many tables inport ok but during an import of a table of abour 800,000
rows
| it aborts with a segmentation fault. There is nothing in the alert log or
a
| core dump.
|
| where else can i look for what possibly causes the error. The error is
| pasted below.
|
| thanks
|
| Tom
|
| Import: Release 9.2.0.1.0 - Production on Tue Jul 29 14:33:07 2003
|
| Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
|
|
| Connected to: Oracle9i Release 9.2.0.1.0 - Production
| JServer Release 9.2.0.1.0 - Production
|
| Export file created by EXPORT:V08.01.05 via conventional path
|
| Warning: the objects were exported by auser, not by you
|
| import done in US7ASCII character set and UTF8 NCHAR character set
| import server uses WE8ISO8859P1 character set (possible charset
conversion)
| export server uses US7ASCII NCHAR character set (possible ncharset
| conversion)
| IMP-00046: using FILESIZE value from export file of 4611686018427387904
| . importing users's objects into anotheruser
|
| . . importing table then many tables import ok but then.
|
| . . importing table "TABLENAME" Segmentation fault
|
| and it exists
|

If the dump comes from another system, did you ftp it binary? If it was an ascii ftp you corrupted the dump file. Received on Tue Jul 29 2003 - 15:29:47 CDT