5

I'm trying to create a DBLink. SQL Developer is the client I'm using. The password to my remote user has *'s in it. I'm having trouble figuring this out. This syntax isn't working:

CREATE DATABASE LINK my_link
CONNECT TO daniel identified by *password
USING 'hostname:port/servicename';

I tried '\' and wrapping the password in {}'s,', to no avail. I get a "Command Not Properly Ended" error. Any advice would help. I know it's a simple issue but having trouble figuring it out from googling.

daniel9x
  • 391
  • 2
  • 12
  • 20

1 Answers1

8

Use quotation marks:

CREATE DATABASE LINK my_link
CONNECT TO daniel identified by "*password"
USING 'hostname:port/servicename';
Balazs Papp
  • 41,488
  • 2
  • 28
  • 47