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

you're right. I was trying to rule out the command line and do it interactiviely by just typing in 'exp' and getting prompted. Even with the escape via that method, I get a TNS error. But running it from the command line and escaping the way you described worked fine.

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
        direction."

• William Feather

On Tue, Oct 28, 2008 at 11:37 AM, Jared Still <jkstill_at_gmail.com> wrote:

> 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