Hi.

You don't need to restart anything after a change to the tnsnames.ora file. The worsth thing that can happen is you alter an existing entry, making futuer connections fail, but as long as you are careful, it shouldn't be a problem.

My advice is get someone to test the existing connection as soon as you save the change, and be ready to revert back in case of a problem.

Using this method is OK, but it's quicker to export on the 10g server, compress it, FTP the file to the 9i server, expand it and then import it. exporting across the network is a bit bandwidth hungry. If network bandwidth isn't the problem then go for it

Cheers

Tim...