I have a data warehouse server that's running Redhat AS 2.1 and Oracle 18.104.22.168, and a production database that's running Redhat AS 4.0 and Oracle 10.2.0.3. I need to export tables from the Oracle 10g database and import them into the Oracle 9i database. The Oracle 10g server/database is new. I know I need to use the Oracle 9i exp command to export the data from the Oracle 10 databse, but don't know all the steps needed to do this. I'm a part-time dba so I would appreciate clear/detailed steps on how to get the two servers to talk to each other, and then how to use the exp command from the Oracle 9 server. The documentation I found said to invoke the exp command on the lower version machine using:
EXP user/password@tnsname arguments...
I'm really not sure how to get the new server in the tnsnames on the lower Oracle 9 version. I need to do a full export from the Oracle 10 database. Any help would be greatly appreciated. Thanks!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!