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 ...