Quote Originally Posted by mojo78
Hi Tim,
Regarding performing the export on the 10G server, presumably you mean using the 9i version of exp (i've found a few forums on the Web where people say you must use the exp from the earlier version when going backwards, e.g. from 10g to 9i)?
You're quite correct. I got caught up in the transfer speed and forgot about the version difference. For erference, the matrix is here:

http://download-uk.oracle.com/docs/c...htm#sthref2854

Just to expand a little on the process:

- Log into the 9i server.

- Edit the $ORACLE_HOME/network/admin/tnsnames.ora file to include an entry pointing to the 10g server.

- Issue the export command on the 9i server, like:

exp username/password@db10g file=.. log=.. owner=.. etc.

Both the log and the dump file will be created on the 9i server.

Cheers

Tim...