Restart required when editing oracle tnsnames.ora?

[mojo78]

FYI, i followed your advice and everything worked smoothly. On the 9i server, I edited tnsnames.ora to add a connection descriptor for the database on the 10G server, which caused no problems with the other tablespaces as i was fearing.

Then, as suggested and still on the 9i server i issued the command 'exp username/password@TNSENTRY ' , where are the basic exp options such as file=, etc. and TNSENTRY is the name given to the connection descriptor in tnsnames.ora, i.e. TNSENTRY = ( DESCRIPTION = (ADDRESS_LIST= .. ) (CONNECT_DATA= ... ) ).

That led to the 10G data being exported to a dump file on the 9i server, which could be imported as normal using the 9i version of the imp utility.

Thanks very much for all your help, it's very much appreciated.

Maurice