Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> redhat 7.3 oracle 9.2 import problem

redhat 7.3 oracle 9.2 import problem

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Tue, 29 Jul 2003 20:26:38 GMT
Message-ID: <2MAVa.3451$rt3.31796453@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 Received on Tue Jul 29 2003 - 15:26:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US