CODEWITHSUNDEEP
oracle11g
Stefania
Stefania

Reputation: 683

Oracle Database link with error

I'm trying to create a database link form an Oracle server to another. The command I'm using is:

 create public database link mylink connect to myuser identified by 0000 authenticated by myuser identified by 0000 using 'myTNSNameRemoteServer';

sqlplus give me this error:

ERROR at line 1:
ORA-00933: SQL command not properly ended

Putting the '*' under the first character of the password in its first instance.

Have I to escape it in someway?

Thanks

Upvotes: 2

Views: 6043

Answers (3)

Stefania
Stefania

Reputation: 683

The solution was to double quote the password: 

create public database link mylink connect to myuser identified by "0000" authenticated by myuser identified by "0000" using 'myTNSNameRemoteServer';

Upvotes: 5

CompEng
CompEng

Reputation: 7416

you can try this:

CREATE DATABASE LINK "dblink_name"
             CONNECT TO "user_user"
             IDENTIFIED BY "user_pass"
             USING '(DESCRIPTION =
                (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = "user_server" )(PORT ="user_port" ))
                )
                (CONNECT_DATA =
                  (SERVICE_NAME = "user_service_name")
                  (SRVR = DEDICATED)
                )
              )' ;

Upvotes: 3

RaviSK
RaviSK

Reputation: 13

Try this one: CREATE DATABASE LINK ABCD CONNECT TO USER IDENTIFIED BY PASSWORD USING 'DBALIASAME';

Upvotes: 0

Related Questions