Database Reference
In-Depth Information
EG Egypt 4
FR France 1
IL Israel 4
IN India 3
IT Italy 1
JP Japan 3
KW Kuwait 4
ML Malaysia 3
MX Mexico 2
MY Myanmar 3
NG Nigeria 4
NL Netherlands 1
NP Nepal 3
SG Singapore 3
SY Syria 4
TK Turkey 4
UK United Kingdom 1
UR Uruguay 2
US United States of America 2
VT The Vatican 1
ZM Zambia 4
ZW Zimbabwe 4
32 rows selected.
SQL>
SQL*Loader express mode generates a bad file, and it also generates a SQL*Loader
control file and places it in the log file, purely for your convenience.
Default Values Used by SQL*Loader Express Mode
You can override the defaults on the command line, but otherwise SQL*Loader in express
mode has these characteristics:
It uses a file named
table-name.dat
in the current directory.
■
It uses the external table load method. SQL*Loader express mode will switch to direct
path load if there are specific errors, such as when the loading user does not have the
privilege to create a directory in the PDB:
■
SQL*Loader-816: error creating temporary directory object SYS_SQLLDR_XT_
TMPDIR_0
0000 for file countries.dat
ORA-01031: insufficient privileges
SQL*Loader-579: switching to direct path for the load
Search WWH ::
Custom Search