RE: Re[2]: Imp abnormally terminated without errors.

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Wed, 07 Mar 2001 12:58:09 -0800
Message-ID: <F001.002C649C.20010307122602@fatcity.com>

You can try importing with a SHOW=Y to check for corruption and to see where it stops.

Henry

-----Original Message-----
Sent: Wednesday, March 07, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L

I've also experienced this one time in the past, but there was one added piece
to the puzzle. I had ftp'd the dump file from one machine to another and had
done so in ASCII mode by accident. Retransferring the file in BINARY mode fixed
the problem.

Dick Goulet

____________________Reply Separator____________________
Author: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
Date:       3/7/2001 11:15 AM

I had this happen once. The export seemed to go okay but when I went to import it everything fell apart. Try doing the export again. When I tried it again it worked. Oracle support had to reason for it.

Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, March 06, 2001 1:00 AM

Dear All,

Has anyone had this experience?

Recently, when I imported a database dump with a series of 2G dum files by pipe(this worked before), the import always terminated abnormally without errors. I have checked the alert log file and the import log file. I checked the rollback segments, redo log files, the data and indexes spaces as well. Everything is normal for me.

What could it be the cause?

Thanks very much for your advice.

This is on Solaris 2.7 with Oracle 8.1.5EE

Chuan

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ruth Gramolini
INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Henry Poras
INET: Henry.Poras_at_ctp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------