Re: create dblink with & in password??

You need to use the commands ACCEPT and PROMPT. Try Including the following line just before create database link command.

ACCEPT 1ST PROMPT ENTER THE VALUE OF 1ST In fact you can hide your output also. Please refer to ACCEPT command help in SQL*Plus.

-- 
Vijaya Kumar Vardhineni
Oracle DBA, EDS
Plano, TX
George Dau <gedau_at_mim.com.au> wrote in article
<32d53ca0.335768759_at_203.12.176.153>...


> 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

>