-
Title
Error running export command through the command line: "ORA-12705: Invalid or unknown NLS paramet -
Description
Error running export command through the command line: "ORA-12705: Invalid or unknown NLS parameter value specified ". Error does not occur connecting to database via Toad executable.
-
Cause
Multiple clients installed on the machine may have specific NLS parameter settings causing the error message.
-
Resolution
Force a specific oracle client to be used connecting to database via command line by using the Ocidll parameter.
Locate the Oraclient*.dll file on the machine. There will be one file for each client installed. By default, this file will be under the BIN folder of each oracle home. Note the path and file name of this file. Add the following parameter to the command line statement:
ocidll=<oracle home>BIN<dll file name>
The command line should look like the below:
"C:\Program Files\Quest Software\Toad for Oracle\toad.exe" ocidll=<oracle home>\BIN\<dll file name> connect=<username>/<password>@<database name> EXP=<path and file name of export file>