-
Importing data into 9i
Hello,
I need to export data in a 10g database and then import it in a 9i database. I read some docs online that said, in order to do so I need to use exp utility from 9i to export data on 10g and then only I can import that data in 9i.
I wanted to know if there is any particular procedure to follow to use oracle 9i's export utility on 10g or I just need to copy the exp binary from the 9i db machine to the 10g db machine and use it
Thanks a lot
-K
-
done need to copy exp at all (won't work if you do that)
Just use exp from the 9i client and set up the 10g database in your tnsnames.ora file