Re: IMPORT error

From: Maya Katincic <maya_at_websoft.com.au>
Date: Sat, 03 Oct 1998 23:54:42 +1000
Message-ID: <36162CA2.FAA9F77D@websoft.com.au>

This can happen if the dump file (export file) was ftp -ed
without specifying 'bin' transfer mode. That can cause
corruption.

Regards,
Maya Katincic
Database Consultant

GHouck wrote:

mike_andrew@usiva.com wrote:
>
> Hello all-
>
> Getting a strange import error when I try to import user
> Oracle 7.2.3 on HP/UX A.9
>
> . . importing table                     "OTF_USER"        324 rows imported
> . . importing table                    "PC_RA_LOG"       1746 rows imported
> . . importing table                "PC_RA_REMARKS"         21 rows imported
> . . importing table         "PC_STATEMENT_REMARKS"         13 rows imported
> . . importing table                     "PC_USERS"         65 rows imported
> . . importing table             "POINT_OF_CONTACT"          0 rows imported
> . . importing table                 "PRIORITY_BOX"          2 rows imported
> . . importing table               "PURCH_CARD_LOG"
> IMP-00009: abnormal end of export file
> Import terminated successfully with warnings.
>

Mike,

Looks to me like 1) a corrupted export file, or 2) a version
difference between the export file and import dbs.

Yours,

Geoff Houck
systems hk
hksys@teleport.com
http://www.teleport.com/~hksys

  Received on Sat Oct 03 1998 - 08:54:42 CDT