SQL*Loader is capable of loading from multiple files in one session. When multiple input files are used, SQL*Loader will generate multiple bad files and discard files--one set for each input file.
The following three datatypes are used in this control file.
- CHAR
Tells SQL*Loader that a field is a text field.
- INTEGER EXTERNAL
Tells SQL*Loader that a field is an integer represented using the text digits "0" through "9".
- DECIMAL EXTERNAL
Tells SQL*Loader that a field is a decimal value represented using the text digits "0" through "9" and an optional decimal point (".").
In the control file,
The keyword FILLER identifies the eight fields that are not being loaded into the database. Their names do not matter, but the same naming convention has been followed as for all the rest of the fields.
TIP: FILLER fields are a new feature in Oracle8i. If you are using a release prior to the Oracle8i release, SQL*Loader will not recognize the FILLER keyword.
No comments:
Post a Comment