SET /P ORA_SCO_TARGET_DBSTR=Please input Oracle ACOOP IP/SID = 127.0.0.1/icoop
SET /P ORA_SCO_TARGET_USR=Please input Oracle ACOOP User(Upper Case) =ISCOTRN  
SET /P ORA_SCO_TARGET_PWD=Please input Oracle ACOOP Password(Lower Case)  =iscotrn
SET /P ORA_TARGET_DBSTR=Please input Oracle ICOOP IP/SID = 127.0.0.1/icoop
SET /P ORA_TARGET_USR=Please input Oracle ACOOP User(Upper Case) =ACOUDTRN   
SET /P ORA_TARGET_PWD=Please input Oracle ACOOP Password(Lower Case)  =acoudtrn

echo quit|echo drop database link ACOOPSERV;|sqlplus %ORA_TARGET_USR%/%ORA_TARGET_PWD%@%ORA_TARGET_DBSTR% 
echo quit|echo CREATE DATABASE LINK ACOOPSERV CONNECT TO %ORA_SCO_TARGET_USR% IDENTIFIED BY %ORA_SCO_TARGET_PWD% USING '%ORA_SCO_TARGET_DBSTR%';|sqlplus %ORA_TARGET_USR%/%ORA_TARGET_PWD%@%ORA_TARGET_DBSTR% 
echo quit|echo create or replace synonym MBMEMBMASTER for %ORA_SCO_TARGET_USR%.MBMEMBMASTER@ACOOPSERV;|sqlplus %ORA_TARGET_USR%/%ORA_TARGET_PWD%@%ORA_TARGET_DBSTR% 

rem select * from MBMEMBMASTER ; = select AM.* from ACOUDTRN.MBMEMBMASTER AM ;