SQL & PL/SQL

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!

can't create database link when password has special character

Darren2Dec 30 2008 — edited Jan 2 2009

I'm trying to execute the following statement within sqlplus

create database link alpha connect to scott identified by tiger! using 'db_alpha'

note that the password for the account has an exclamation point in it. the command fails. I've tried placing the password in quotes (') and double-quotes ("). The double-quotes work, but then the link fails to function properly.

We are required to have a special character in our passwords... so how do I get that special character into the password for the database link?

Thanks in advance,
Darren

This post has been answered by Solomon Yakobson on Jan 1 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 30 2009

Added on Dec 30 2008

5 comments

9,944 views