Oracle7 Server Messages
00100-00199: Command Line
SQL*Loader-100 syntax error on command line
Cause: | Possible causes for this error include: placing a positional argument after keyword arguments, misspelling a keyword, not balancing parentheses or quotes, or leaving space between the operator, '=', and an argument. | |
Action: | Check the command syntax and the spelling, then retry. | |
SQL*Loader-101 invalid argument for username/password
Cause: | The username/password argument specified on the command line was not recognized. Another argument (not identified by a keyword) could be in the position where username/password is expected. | |
This error could also result from a spelling mistake. The password, if
present, must be separated by a slash (/). No spaces can appear between the slash and username or password. Otherwise, SQL*Loader sees them as multiple arguments.
Action: | Check the format of the username/password argument, which is the first argument on the command line, if arguments are given without keywords. | |
SQL*Loader-102 invalid control file name on command line
Cause: | The control filename specified on the command line was not recognized. It could be misspelled, or another argument (not identified by a keyword) could be in its place. One possible cause is the existence of a space between username and password. See error 101, above. | |
Action: | Check the spelling and position of the arguments on the command line. | |
SQL*Loader-103 invalid log file name on command line
Cause: | The log file name specified on the command line was not recognized. It could
be misspelled, or another argument (not identified by a keyword) could be in its place. | |
Action: | Check the spelling and position of the arguments on the command line. | |
SQL*Loader-104 invalid bad file name on command line
Cause: | The bad file name specified on the command line was not recognized. It could be misspelled, or another argument (not identified by a keyword) could be in its place. | |
Action: | Check the spelling and position of the arguments on the command line. | |
SQL*Loader-105 invalid datafile name on command line
Cause: | The datafile name specified on the command line was not recognized. It could be misspelled, or another argument (not identified by a keyword) could be in its place. | |
Action: | Check the spelling and position of the arguments on the command line. | |
SQL*Loader-106 invalid discard file name on command line
Cause: | The discard file name specified on the command line was not recognized. It could be misspelled, or another argument (not identified by a keyword) could be in its place. | |
Action: | Check the spelling and position of the arguments on the command line. | |
SQL*Loader-107 invalid maximum number of discards
Cause: | The argument's value is inappropriate, or another argument (not identified by a keyword) is in its place. | |
Action: | Check the command line and retry. | |
SQL*Loader-108 invalid number of logical records to load
Cause: | The argument's value is inappropriate, or another argument (not identified by a keyword) is in its place. | |
Action: | Check the command line and retry. | |
SQL*Loader-109 invalid number of logical records to skip
Cause: | The argument's value is inappropriate, or another argument (not identified by a keyword) is in its place. | |
Action: | Check the command line and retry. | |
SQL*Loader-110 invalid maximum number of errors
Cause: | The argument's value is inappropriate, or another argument (not identified by a keyword) is in its place. | |
Action: | Check the command line and retry. | |
SQL*Loader-111 invalid number of rows for bind array or data saves
Cause: | The argument's value is inappropriate, or another argument (not identified by a keyword) is in its place. | |
Action: | Check the command line and retry. | |
SQL*Loader-112 invalid maximum bind array size
Cause: | The argument's value is inappropriate, or another argument (not identified by a keyword) is in its place. | |
Action: | Check the command line and retry. | |
SQL*Loader-113 invalid silent mode option
Cause: | The only valid options for the SILENT command-line argument are ALL, ERROR, FEEDBACK, or HEADER. The argument could be misspelled, or another argument (not identified by a keyword) could be in its place. | |
Action: | Check the command line and retry. | |
SQL*Loader-114 error in OPTIONS statement
Cause: | Command line options specified in the control file with the OPTIONS clause were found to be incorrect. | |
Action: | Check the format of the OPTIONS clause in the control file. | |
SQL*Loader-115 invalid direct path option
Cause: | The only valid options for the DIRECT command-line argument are TRUE or FALSE. The argument could be misspelled, or another argument (not identified by a keyword) could be in its place. | |
Action: | Check the command line and retry. | |
SQL*Loader-116 error prompting for password
Cause: | An internal error has occurred. | |
Action: | Contact customer support. | |