Create Database Link Error
324137May 27 2010 — edited May 31 2010Hello 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.