SAP Database link - Urgent

[brhynold]

Does anyone out there know how to create a database link in a SAP database to another Oracle database. We are trying to go live with a new application at midnight tonight and the SAP administrator is on vacation and didn't leave instructions with his juniors on how to create this link.

Thanks

[mauric]

edit the tnsnames.ora on your $ORACLE_HOME/network/admin
and try it with command tnsping

after this you be able to create a database link from your schema with a comand:

SQL>create database link connect to
identified by using '';

hope this helps

[mauric]

edit the tnsnames.ora on your $ORACLE_HOME/network/admin
and try it with command tnsping

after this you be able to create a database link from your schema with a comand:

SQL>CREATE DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING 'connect_string';


hope this helps