If you have an Oracle user with an '@' symbol in it's password, the following error shows in the SQL*Loader wizard when it runs and imports a .ctl file:
'SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12154: TNS:could not resolve the connect identifier specified'
If you run the following command in CMD, you also get the same error... e.g.:
sqlldr loader/"lo@der"@orcl control=test123.ctl
This would appear as though it is an Oracle issue, however if you use this different command below, it works in CMD:
sqlldr loader/\"lo@der\"@orcl control=test123.ctl
Can Toad incorporate this alternative command in such scenarios when a password has an '@' symbol in it?
WORKAROUND:
You can use a command such as this in the Windows Command Prompt:
sqlldr loader/\"lo@der\"@orcl control=test123.ctl
STATUS:
Waiting for fix in a future release of Toad for Oracle
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center