Another way would be to set init.ora parameter remote_listener of new 10g DBs to the listener on the old host. This way database will register itself to that listener. If service name is no different, client would be able to connect as usual. It's about the same as hardcode it in the listener.ora but might be a bit simpler. -- Best regards, Alex Gorbachev -- //www.freelists.org/webpage/oracle-l