Create new Database Link Problem

[rajujrk]

Hi,


I am not able to create the Database link in my Oracle 11g. My Statement looks like below

CREATE DATABASE LINK mylink CONNECT TO <username>
IDENTIFIED BY <pwd> USING <tns_service_name>;

and it shows the below error as

Error starting at line 2 in command:
CREATE DATABASE LINK mylink CONNECT TO <username> IDENTIFIED BY <pwd> USING <tns_service_name>
Error at Command Line:2 Column:70
Error report:
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 -  "SQL command not properly ended"
*Cause:    
*Action:

Given tns service name is correct

Thanks in Advance

[rajmani]

Problem seems to be with your parameters not with the statement:

CREATE DATABASE LINK "mydblink" CONNECT TO "MYDB" IDENTIFIED BY mypassword USING 'tns.world';