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 -> Re: Export (HPUX11.00 Oracle 8.0.4.0.0) CANNOT be imported into (HPUX10.20 Oracle 8.0.5.0.0)??

Re: Export (HPUX11.00 Oracle 8.0.4.0.0) CANNOT be imported into (HPUX10.20 Oracle 8.0.5.0.0)??

From: peter <wu0020_at_home.com>
Date: Fri, 17 Dec 1999 17:27:06 GMT
Message-ID: <Knu64.6200$ZT5.3341173@news1.rdc1.on.wave.home.com>


Looks like you export file got corrupted during transfer. If this is not case, you can do this:

import to your HPUX10.20 from your HPUX11.00. I think you know what I mean. Cheong wrote in message <38585be4_at_news.lhsgroup.com>...
>Hello:
>
>I have a seemingly clean export file done on HPUX 11.00, Oracle 8.0.4.0.0:
>
>---------------------------------------------------------------------------
-
>---------------------------
>Connected to: Oracle8 Enterprise Edition Release 8.0.4.0.0S - Production
>With the Partitioning and Objects options
>PL/SQL Release 8.0.4.0.0S - Production
>Export done in US7ASCII character set and US7ASCII NCHAR character set
>
>About to export specified tables via Conventional Path ...
>. . exporting table RA_SIM_ICC_FORMAT 3 rows exported
>. . exporting table RA_SIM_PORECEIPT_ALL 221 rows exported
>. . exporting table RA_SIM_POTRAILER_ALL 271 rows exported
>. . exporting table RA_SIM_PO_HEADER_ALL 116 rows exported
>Export terminated successfully without warnings
>---------------------------------------------------------------------------
-
>--------------------------------
>
>But this same seemingly clean export file CANNOT be imported into another
HP
>platform running HPUX 10.20, Oracle 8.0.5.0.0:
>
>============================================================
>lab::/tmp $ imp parfile=imp.par
>
>Import: Release 8.0.5.0.0 - Production on Thu Dec 16 10:46:36 1999
>
>(c) Copyright 1998 Oracle Corporation. All rights reserved.
>
>
>Connected to: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
>With the Partitioning and Objects options
>PL/SQL Release 8.0.5.0.0 - Production
>
>IMP-00010: not a valid export file, header failed verification
>IMP-00021: operating system error - error code (dec 2, hex 0x2)
>IMP-00000: Import terminated unsuccessfully
>lab::/tmp $
>=============================================================
>
>Was it because Oracle export/import OS dependent (from 32 bits machine -->
>64 bits machine or vice versa), although every single Oracle book I read
>says otherwise??
>
>Any suggestion / comment / sharing / indication are most welcome.
>
>Thank you all, have a wonderful day.
>
>Regards,
>Cheong
>
>
Received on Fri Dec 17 1999 - 11:27:06 CST

Original text of this message

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