Home » RDBMS Server » Server Utilities » IMp-00010 during export (10.2.0.3,Win2k3)
IMp-00010 during export [message #378455] Tue, 30 December 2008 08:52 Go to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Hello,

I am trying to perform an import on a database but I keep on having
an error I couldn't fix.

Below is the command I used and the error returned:

Microsoft Windows XP [version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrateur>set oracle_sid=meta4

C:\Documents and Settings\Administrateur>imp system/m4prod fromuser=m4prod touse
r=m4prod file='c:\m4prod_5_291208.dmp' log='m4prod_5_291208.log' grants=n commit
=y statistics=recalculate

Import: Release 9.2.0.1.0 - Production on Ma Dec 30 07:52:28 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connect┌ Ë : Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Product
ion
With the Partitioning, OLAP and Data Mining options

IMP-00010: en-t█te de fichier d'export non valide ; ┌chec de la v┌rification
IMP-00000: Proc┌dure d'import termin┌e avec erreur

C:\Documents and Settings\Administrateur>

I would like to mention that, there are two databases on that server. One
is using 9i, the other one -the one I am importing into- uses 10g. The export
file comes from a 10g database, and I worked on some other pcs.

Any tips?

Thanks in advance.

[Updated on: Tue, 30 December 2008 08:57]

Report message to a moderator

Re: IMp-00010 during export [message #378458 is a reply to message #378455] Tue, 30 December 2008 09:07 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
IMP-00010: en-t█te de fichier d'export non valide ; ┌chec de la v┌rification
IMP-00000: Proc┌dure d'import termin┌e avec erreur


>>The export file comes from a 10g database
Seems you are using a 9i version of imp to import.
Use 10g version of imp.
Just set ORACLE_HOME to 10g home

[Updated on: Tue, 30 December 2008 09:07]

Report message to a moderator

Previous Topic: Loading batch
Next Topic: changing tablespace during import
Goto Forum:
  


Current Time: Sat Dec 10 11:10:48 CST 2016

Total time taken to generate the page: 0.10114 seconds