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/Import of database

Re: Export/Import of database

From: konsultant_1 - konsultancIT.pl <konsultant_1_at_konsultancIT.pl>
Date: Tue, 17 Jun 2003 14:23:55 +0200
Message-ID: <3EEF085B.20202@konsultancIT.pl>


Zulin Zwindy wrote:
> Hi all,
>
> I cannot import an exported database.
>
> I have exported the database with the following configuration on a Unix
> system:
>
> Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit
> Production
> With the Partitioning option
> JServer Release 9.2.0.3.0 - Production
> Export done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character set
>
>
> Then I have tried to import the dump file on a Windows NT Server with the
> following error:
>
> Import: Release 9.2.0.3.0 - Production on Tue Jun 17 11:18:11 2003
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Connected to: Personal Oracle9i Release 9.2.0.3.0 - Production
> With the OLAP and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
> IMP-00010: not a valid export file, header failed verification
> IMP-00000: Import terminated unsuccessfully
>
>
> It was a binary transfer of the dumpfile. And I have set the nls_language to
> AMERICAN_AMERICA.WE8PC850.
>
>
> Does anybody know that problem?
>

Hi,

Please send the parameter file, used to IMPORT the database.Or look at the EXPORT .log file to chceck the EXPORT has been completed.

Maybe the .dmp file is corrunpted or has different header than IMP expected.

-- 

   www.konsultancIT.pl
Oracle&MS-SQL consulting
Received on Tue Jun 17 2003 - 07:23:55 CDT

Original text of this message

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