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

Thread: oracle

  1. #1
    Join Date
    Apr 2003
    Location
    india
    Posts
    13

    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
    Posts
    736
    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