DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SAP database links - Urgent

  1. #1
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197

    Question SAP database links - Urgent

    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
    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Prerequisites
    To create a private database link, you must have CREATE DATABASE LINK system privilege. To create a public database link, you must have CREATE PUBLIC DATABASE LINK system privilege.

    You must have CREATE SESSION privilege on the remote Oracle database.
    Sys or system.

    Net8 must be installed on both the local and remote Oracle databases.

    To access non-Oracle systems you must use the Oracle Heterogeneous Services.


    CURRENT_USER Example
    The following statement defines a current-user database link:

    CREATE DATABASE LINK sales.hq.acme.com
    CONNECT TO CURRENT_USER
    USING 'sales';

    Fixed User Example
    The following statement defines a fixed-user database link named SALES.HQ.ACME.COM:

    CREATE DATABASE LINK sales.hq.acme.com
    CONNECT TO scott IDENTIFIED BY tiger
    USING 'sales';

    Once this database link is created, you can query tables in the schema SCOTT on the remote database in this manner:

    SELECT *
    FROM emp@sales.hq.acme.com;
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width