I have a data warehouse server that's running Redhat AS 2.1 and Oracle 184.108.40.206, 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!
March 17, 2008 7:36 PM
December 16, 2009 12:07 PM