Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: create dblink with & in password??
George Dau wrote:
>
> G'day Oraclers,
> The SQL Language Reference Manual says on pages 2-9, then shows in an example on
> 2-10 that I can use an & in an object if I double quote the name.
>
> Doesnt work with a database link under Oracle 7.2.2. Here is my script:
>
> #!/bin/sh
> sqlplus system/manager <<EOSQL
> create database link oen.prod
> connect to oen identified by "safety&1st"
> using 'T:bcscost1:OENP';
> exit;
> EOSQL
>
> This produces:
>
> bcstail1:/u02/home/oracle/admin/OEND/adhoc>./dblink.sh
>
> SQL*Plus: Release 3.2.2.0.0 - Production on Mon Jan 6 10:29:38 1997
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>
> Connected to:
> Oracle7 Server Release 7.2.2.4.0 - Production Release
> With the distributed, replication and parallel query options
> PL/SQL Release 2.2.2.3.0 - Production
>
> SQL> 2 3 Enter value for 1st: old 2: connect to oen identified by
> "safety&1st"
> new 2: connect to oen identified by "safetyexit;"
>
> Database link created.
>
> SQL> Disconnected from Oracle7 Server Release 7.2.2.4.0 - Production Release
> With the distributed, replication and parallel query options
> PL/SQL Release 2.2.2.3.0 - Production
>
> It has infact created the link, but obviously the password is wrong. The book
> says I should be able to do this. Any ideas?
>
> TIA
> George Dau
> gedau_at_mim.com.au
Try SET SCAN OFF. This will turn off all &substitution so you will need to turn it back on if you need it later in your script.
-- James H. Yoshii Intellitech Business Solutions yoshii_at_planet.netReceived on Wed Jan 08 1997 - 00:00:00 CST
![]() |
![]() |