Oracle7 Server Messages

Contents Index Home Previous Next

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.

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.


Contents Index Home Previous Next