ORACLE - IMP-00010: not a valid export file

[Raj D.]

IMP-00010 : It seems that version problem.

And make sure ftp'ed with binary version.

All seems due to version mismatch , export dump created on higher version can't be imported on lower version.

Cheers,
Raj.

[Patti Johnson]

Stephen,

On the 9i server add another entry into your tnsnames.ora file that refers back to the 10g database. This is the same entry that you would put on any client machine to communicate with the 10g database.

If you are unsure of the correct values for port, service_name, etc you can use the tnsping command from the 10g server to get the correct values. Then just add an entry similar to the one you listed with the new values.

Test the connection from the 9i server using sqlplus.
sqlplus user/passwd@10g_connect_string

Once that works you can run the export command on the 9i server and create the dump file locally.

exp user/passwd@10g_connect_string.

You will have problems if you are using any new 10g features that are not supported on 9i.

Patti

[TwoProc]

Re: tnsnames.ora addition:

Let's say the 10G machine is "srva" and the port is 1522, and the ORACLE_SID on THAT machine is MYDB.

We'll name the connection "MYDB" by adding this to the tnsnames.ora file:

MYDB = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=srva)(PORT=1522))
(CONNECT_DATA=(SID=MYDB))
)

[TwoProc]

The above entry's formatting got pretty toasted by the itrc server, but it's not that important, you can put all the above on the same line.