oracle

[dinkar]

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

[akhadar]

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.