[code language=”sql”]
#!/bin/ksh

sqlplus -s "/ as sysdba" <<EOF

— create a public link for all to use

— drop public database link sybase;

— CREATE PUBLIC DATABASE LINK sybase CONNECT TO "automation" IDENTIFIED BY "password" USING ‘db4sybase’;

drop public database link testora;

CREATE PUBLIC DATABASE LINK testora CONNECT TO "automation" IDENTIFIED BY "password" USING ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname.commitdba.com)(PORT=49129))(CONNECT_DATA=(SID=dg4sybase))(HS=OK))’;

— select host from dba_db_links;

select * from dual@TESTORA;
— select * from dual@db4sybase;

— select * from dual@sybase;

EOF

[/code]