I am trying to make a link from one database to another. When I run the following code, I get the standard "Statement Processed." message:
If I go into Oracle DBA Studio and do a test, it returns the message that the link is not active. I have verified that the account I use to create the link has permissions to create links and that the database name that I am trying to link to is correct. I also checked that the login and password that I am trying to connect with are correct and that it has create session permissions. Anyone have any ideas or a way that I can find out why it is not active? Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.
Code:
CREATE DATABASE LINK DB.MyCom.COM
CONNECT TO MyLogin IDENTIFIED BY MyPasswd
USING 'DB.MyCom.COM'
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.