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

  • From: Lyndon Tiu <ltiu@xxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 28 Oct 2008 08:27:25 -0700

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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2008