Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: sirus.j@gmail.com
Newsgroups: comp.databases.oracle.tools
Subject: Db link creation
Date: 2 Nov 2005 04:43:03 -0800
Organization: http://groups.google.com
Lines: 21
Message-ID: <1130935383.379038.23130@g43g2000cwa.googlegroups.com>
NNTP-Posting-Host: 196.15.16.20
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1130935388 2033 127.0.0.1 (2 Nov 2005 12:43:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 2 Nov 2005 12:43:08 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=196.15.16.20;
   posting-account=F0ZJ0A0AAAA4eklo4uyOD5CddqWTVu7c
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:69517

Hi,
  I'm stuck up with an intersting issue on DB links. The syntax (which
I presume most of u guyzz are very familiar with) for creating a DB
link is as follows:

create database link <link_name> connect to <username> identified by
<password> using '<connection string>'


Notice that username and password are NOT in quotes.. The problem
arises when the password contains special characters (like ',',';','~'
etc) or when the password starts with a number, the latter being a very
relevant issue.. The remote database can certainly allow passwords
starting with numbers or containing special characters, but the command
gives an invalid SQL exception as there are many restrictions on schema
object names.. Moreover, these objects (like the password field) cannot
be bound using :1 in dynamic SQL.. So far, I'm stumped as far as
creating a db link with special characters in passwords (or passwords
starting with numerals) is concerned.. Any workarounds/ solutions
anyone ??????