Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: connect using host:port:sid
"Sunil" <sunil_franklin_at_hotmail.com> wrote in message
news:ppKE9.2$Ws2.85_at_news.oracle.com...
> This Does not Work :-
> 1>sqlplus
>
scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=inponi)(Port=1521))(CO
> NNECT_DATA=(SID=iasdb))) @script_name.sql parameter1 parameter2
> 2>
just remove spaces from your connect string or enclose one by the " sign:
sqlplus
"scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=inponi)(Port=1521))(C
ONNECT_DATA=(SID=iasdb)))" @script_name.sql parameter1 parameter2
Received on Wed Nov 27 2002 - 02:24:54 CST