Error creating database link in Oracle

Question

I have two databases and need to write a cross database query. So I'm trying to create a database link.

CREATE PUBLIC DATABASE LINK DBLink CONNECT TO SchemaName IDENTIFIED BY 123 using 'DBName';

When I executing this query it's take following error "ORA - 00933:SQL command not properly ended". Can anybody explain me where is the mistake?

P.S. I'm using SQL Developer.

Gleb · Accepted Answer · 2014-09-05 05:19:54Z

4

I actually solve this problem. The problem was in the numbers used as password. To fix it use double quotes in password like this:

CREATE PUBLIC DATABASE LINK DBLink CONNECT TO SchemaName IDENTIFIED BY "123" using 'DBName';

answered Sep 5, 2014 at 5:19

Gleb

1,4321 gold badge24 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I don't think so. In my case i have only letters as password.