Load Data window
- Input file
- Type a directory path to a .data file, or click Browse to
open a window so that you can look for a file.
- File format
- Specify options for the format of the .data file. You must ensure that
the format that you specify is the same format that the input file uses.
- Column delimiter
- Specify the character to use as a column delimiter in the .data file.
- Character string delimiter
- Specify the character to use as a string delimiter in the .data file.
- Replace existing data
- Select to specify that all existing data is deleted and replaced with
the data from the .data file. If you do not specify this option, the table
is directly loaded and any existing rows are preserved. There is a possibility
when you do not replace existing data that data might be duplicated. If data
is duplicated and the table has unique constraints or unique indexes, the
load might fail.