Database Software

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 LRM-00116: error sintax

3414696Jun 1 2017 — edited Jun 2 2017

Hi All,

This command return error Sintaxe - SQLDR -100.

The error is LRM-00116: error sintax 'User777/Pwd!20' ap¾s '='

Command.

sqlldr userid=User777/Pwd!201777@datadw1//(description=(address=(host=192.168.10.45)(protocol=tcp)(port=1521))(connect_data=(service_name=datadw1))) bad='bad_file.txt' control='control.ctl' data='L777T.csv' log='log.txt' direct='true'

I changed the password because I believed it was due to the '!' Character. But I have not gone beyond that point.

Thanks for any criticism.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2017

Added on Jun 1 2017

#database-key-features, #export-import-sql-loader-external-tables

2 comments

4,082 views