Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page