Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question

From: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date: Tue, 28 Oct 2008 08:27:25 -0700
Message-Id: <200810281527.m9SFRP0u016728@rm-rstar.sfu.ca>

('binary' encoding is not supported, stored as-is)
Hi guys,

Question:

If this works:

sqlplus user/pass@"(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(CONNECT_DATA=(SID=MYORA)))"

Why does this not work:

exp user/pass@"(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(CONNECT_DATA=(SID=MYORA)))"

Error:

LRM-00116: syntax error at 'ADDRESS' following '('

Any tips and suggestions greatly appreciated.

Thanks.

--

Lyndon Tiu
--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 28 2008 - 10:27:25 CDT

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]