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>
Hi guys,
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