Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> redhat 7.3 oracle 9.2 import problem
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 Received on Tue Jul 29 2003 - 15:26:38 CDT
![]() |
![]() |