Importing data into 9i
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
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
Click Here to Expand Forum to Full Width