How abt using DBlink, if the data needed from few tables?
I was looking into client interoperability for someone recently. According to Metalink note 207303.1 10g has never been certified with 7.3.4 (earliest version on Matrix). Going from a 10g client to a 7.3.4 server, you can expect an ORA-3134 if you try it (assuming the note is to be believed). 9.0.1 to 7.3.4 was once a certified combination, but nothing higher than that was ever supported.
i inserted tnsnames.ora of the 10g in my unix 7i server
but it seems it does not work since i am trying to connect it first
via sqlplus to check if the exp module will connect to my 10g DB.
am i missing something?
ERROR: ORA-01034: ORACLE not available
ORA-07318: smsget: open error when opening sgadef.dbf file.
HP-UX Error: 2: No such file or directory
The problem here is that connections from a 10g client to a 7.3.4 server are not supported. A database link works by make a client connection from one server to the other, hence your problem. I don't think this is a sensible route forward.