Oracle in a Nutshell

Keywords

table_name

Name of the table that you are loading. You may optionally specify an owner name using the owner.table_name format.

partition_name

Specifies the name of a partition, or subpartition, of the table being loaded. Use the PARTITION clause if you are loading a partitioned table and if all the data goes into the same partition.

INSERT | REPLACE | TRUNCATE | APPEND

Specifies the load method on a table-specific basis. This overrides the load method specified for the load as a whole (in the LOAD statement). There are two possible locations in the INTO TABLE clause where these keywords may appear: after the PARTITION specification or after the SORTED specification.

SORTED [INDEXES] ( index_list )

Specifies the name of one or more indexes that match the way in which the input data is sorted on a direct path load. If you specify more than one index name, use a comma-separated list.

SINGLEROW

Used only with direct path loads with APPEND. This keyword specifies that each index entry should be inserted directly into the index, one row at a time. Normally, when loading with APPEND, index entries are accumulated in a temporary storage area and merged into the existing index at the end of the load.

database_filename

Name of a datafile in the tablespace of the table or partition being loaded. This applies only to parallel, direct path loads. When such a load is performed, SQL*Loader uses the specified datafile for any temporary segments that it creates during the load. This allows ...