Database A resides on host A and Database B resides on host B. To create a server on Database A from A-B, I had to catalogue Database B on to host A.
Now, Database B has been moved from host B to host C. I changed the catalogue information on host A to point it to the new host C. But I am having issues creating Nicknames. When I see the diaglog. It says the server is still pointing to host B. Do I need to drop and recreate the server ?