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

Thread: oracle

  1. #1
    Join Date
    Apr 2003

    Question oracle

    we r having 2 servers.
    1-> novell netware 5.1 with oracle 8
    2-> windows 2000 with oracle 8i

    i want craete a database link from oracle8 database to oracle8i

    i have created databaselink using following syntax

    sql>create database link db_link scott identified by tiger using 'oracle';

    link successfully created

    but when iam connecting to that link using following syntax

    sql>select * from sal@db_link;

    iam getting the error mesg like
    database link db_link.us.oracle.com connects to oracle.world
    akhir dil hi hindustani

  2. #2
    Join Date
    May 2001
    If u observe your error statement

    database link db_link.us.oracle.com connects to oracle.world

    your Global_names are conflicting with other parameters.Better make Global_names to false in your Init file and try to create the link again.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.