-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|