Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlldr without tnsnames entry

415622Nov 1 2006 — edited Nov 1 2006

Hi,

I am able to connect to the database using sqlplus as follows
sqlplus user/passwd@''(description=(address_list=(address=(protocol=TCP)(host=machine)(port=1521)))(connect_data=(sid=dbsid)(server=DEDICATED)))'

But I am not able to load data using sqlldr as follows
sqlldr userid=user/passwd@''(description=(address_list=(address=(protocol=TCP)(host=machine)(port=1521)))(connect_data=(sid=dbsid)(server=DEDICATED)))' control=file1.ctl

I got the following error messages
LRM-00116: syntax error at 'address_list' following '('

SQL*Loader: Release 9.2.0.1.0 - Production on Wed Nov 1 13:11:51 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL*Loader-100: Syntax error on command-line

Could anyone help me?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 29 2006

Added on Nov 1 2006

#general-database-discussions

10 comments

3,509 views