Default: If it is omitted, then you are prompted for it. If only a slash is used, then USERID
defaults to your operating system login
Purpose
Syntax and Description
USERID=[username | / | SYS]
Specify a user name. For security reasons, Oracle recommends that you specify only the user name on the command line. SQL*Loader then prompts you for a password.
If you do not specify the USERID
parameter, then you are prompted for it. If only a slash is used, then USERID
defaults to your operating system login.
If you connect as user SYS
, then you must also specify AS SYSDBA
in the connect string.
Restrictions
Because the string, AS SYSDBA,
contains a blank, some operating systems may require that the entire connect string be placed in quotation marks or marked as a literal by some method. Some operating systems also require that quotation marks on the command line be preceded by an escape character, such as backslashes.
See your Oracle operating system-specific documentation for information about special and reserved characters on your system.
Example
The following example specifies a user name of hr
. SQL*Loader then prompts for a password. Because it is the first and only parameter specified, you do not need to include the parameter name USERID
:
> sqlldr hr Password: