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

On Tue, Oct 28, 2008 at 8:27 AM, Lyndon Tiu <ltiu_at_alumni.sfu.ca> 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

--
http://www.freelists.org/webpage/oracle-l