Describe the data in the file to import:
Comma (,)
, Hyphen (-)
, Period (.)
, Space
(one space), Tab
, Vertical Bar (|)
, White Space
(more than one space), or Enter your delimiter here
. The default is Comma (,)
. Use White Space
to deal with a double, non-regular space delimiter. To specify a delimiter not in the list, select Enter your delimiter here
and replace this text with the delimiter.None
, Single Quote (')
, or Double Quote (")
. The default is None
. If you select a field enclosure, the enclosure must be used for all fields. Field enclosures are required if the file being imported contains string names that include spaces, such as "ALL FIELDS".Click Preview to see the first twenty rows of the new table.
Click Advanced Settings to override default settings for the SQL*Loader import operation.
Click Next to continue.
Copyright © 2006, 2008, Oracle. All rights reserved.