- Dedication
- Preface
- I. DBA Tasks
- 1. Introduction
- 2. Installation
- 3. Maximizing Oracle Performance
- 4. Preventing Data Loss
- 5. Oracle Networking
- Oracle Names
- MultiProtocol Interchange
- Connecting to Non-Oracle Databases
- Network Manager Data Storage
- Using Network Manager
- Files Created by Network Manager
- Oracle Net8 Assistant
- Manual Network Configuration
- Sample SQL*Net Files
- SQL*Net Troubleshooting
- 6. Security and Monitoring
- 7. Auditing
- 8. Query Optimization
- 9. Oracle Tools
- 10. The Oracle Instance
- 11. The Oracle Database
- 12. Initialization Parameters
- 13. SQL Statements for the DBA
- SQL Commands by Task
- SQL Command Syntax
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- column_constraint_clause
- auto_extend_clause
- for_clause
- filespec
- autoextend_clause
- global_index_clause
- local_index_clause
- table_constraint_clause
- table_ref_clause
- column_ref_clause
- column_constraint_clause
- index_organization_clause
- segment_attrib_clause
- partition_clause
- autoextend_clause
- 14. The Oracle Data Dictionary
- Static Data Dictionary Views
- Dynamic Performance Data Dictionary Views
- 15. System Privileges and Initial Roles
- 16. Tools and Utilities
SQL*Loader
SQL*Loader is an Oracle-supplied tool that provides a reliable method of bulk loading data into the database from almost any type of external non-database file. The file containing the data to be loaded can contain either fixed- or variable-length records, and the fields in the records can be fixed or variable length as well. The actual data may be character, date, or any of several formats of numeric, including packed decimal and floating-point binary.
SQL*Loader provides the ability to selectively load data based on the values of data elements, and can load multiple tables simultaneously. Records that are not loaded due to errors or improper data values may be placed in a separate discard file for later processing.
The following tasks can be accomplished by SQL*Loader:
Load data from multiple files, which can be of different file types.
Load data from fixed-format, delimited-format (e.g., comma-delimited), or variable-length records.
Perform manipulation of data fields with SQL statements before storing this data in the database.
Load from a variety of datatypes, including DATE, BINARY, PACKED DECIMAL, and ZONED DECIMAL.
Combine multiple records into a single database row.
Create multiple database rows from a single input record.
Generate unique key values for columns as data is loaded.
-
No Comment