hi ALL,

Is there any reason why my db_link is not working between PROD and TEST, I keep getting :TNS error: service name cannot be resolved...which I dont understand as I have entries for both instances in the tnsnames.ora and located in the right place $ORACLE_HOME/network.
the link is from prod to test for a particular schema...DO I have to go into test to create this.

please help..