Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error trying to insert record through database link

I have created a database link and am trying to insert a record into the remote database. For example:

        insert into test@dblink225 
        values('RamaChandra'); 

I am getting the following error:

ERROR at line 1: 
ORA-06401: NETCMN: invalid driver designator 

Please help me.

I think that the dblink was not created correctly.

 
  Create DataBase link dblink225 
  connect to <user> identified by <password> using '<alias in sqlNet>' 

<user> / <password> are valid user names and passwords in the remote database.

<alias in sqlNet> is an sqlNet alias to that database that must exist in the TNSNAMES.ORA in the remote database server and in the local database server. Check out network/admin under the Oracle base directory.

For More Information

Dig Deeper on Oracle error messages

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close