Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create Database Link Error

324137May 27 2010 — edited May 31 2010
Hello all,

I am trying to create a database link (using both SQL Developer and Sql*Plus) and I get the error ORA-00933: SQL command not properly ended.

Here is the statement:

CREATE DATABASE LINK msrtp CONNECT TO msrtp_user IDENTIFIED BY 62ROLDS USING msrtp;

Yes, the global name of the database is msrtp and I have created other db links without any problems.

The problem here is because the password starts with a number. I have no control over the password and can't change it. I have tried enclosing it in single and double quotes but that doesn't work. Is there any way around this other than changing the password?

Oracle 10g

Thanks.
This post has been answered by Mark D Powell on May 27 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2010
Added on May 27 2010
6 comments
2,048 views