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

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: ltiu@xxxxxxxxxxxxx
  • Date: Tue, 28 Oct 2008 09:37:32 -0700

On Tue, Oct 28, 2008 at 8:27 AM, Lyndon Tiu <ltiu@xxxxxxxxxxxxx> wrote:

>
> 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.
>
>
Typically with exp, '(' ,')' and '=' must be escaped.

This worked for me on 10.2.0.3:

exp scott/tiger@
"\(DESCRIPTION\=\(ADDRESS_LIST\=\(ADDRESS\=\(PROTOCOL\=IPC\)\(KEY\=dv99\)\)\)\(CONNECT_DATA\=\(SID\=dv99\)\(SERVICE_NAME\=dv99\)\)\)"

Jared

Other related posts:

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