2 Answers
- Newest
- Most votes
- Most comments
0
The error "-bash: syntax error near unexpected token `('" implies that the problem is with the bash shell and not sql loader.
I suggest you try:
- using the easy connect format: @//host:port/SERVICE_NAME
- quoting and escaping the quotes and brackets the connection string:
\"\(DESCRIPTION=\(ADDRESS_LIST=\(ADDRESS=\(PROTOCOL=TCP\)\(HOST=xxxx-xxxx-xxxxx-xxxx.amazonaws.com\)\(PORT=1521\)\)\)\(CONNECT_DATA=\(SERVICE_NAME=xxxx\)\)\) control=/app/loaddata\"
- using the easy connect format: //host:port/SERVICE_NAME
- putting the userid into a parfile (may still need quotes or escaping)
answered a year ago
0
The option using the easy connect format: @//host:port/SERVICE_NAME worked.
Thanks for your help
answered a year ago
Relevant content
- asked a year ago
- asked a year ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 8 months ago