| IMp-00010 during export [message #378455] |
Tue, 30 December 2008 08:52  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
