Oracle7 Server Utilities User's Guide

Library

Product

---

• Oracle7^(tm) Server Utilities

• Preface
  • Audience
  • How This Book Is Organized
  • Conventions Used in this Manual
  • Your Comments Are Welcome

• Export/Import

• Export
  • Export Basics
  • Warning, Error, and Completion Messages
  • Export Modes
  • Exporting Sequences
  • Exporting LONGs
  • Trusted Oracle7 Server and Export
  • Network Considerations
  • NLS Considerations
  • Using Export
  • Export Parameters
  • Export's Interactive Mode
  • Example Export Sessions
  • Incremental, Cumulative, and Complete Exports
  • Export Utility: Direct Path Export
  • Using Different Versions of Export
  • Creating Oracle Server Version 6 Export Files from Oracle7

• Import
  • Import Basics
  • Warning, Error, and Completion Messages
  • Error Handling
  • Privileges Required to Use Import
  • Import and Stored Procedures, Functions, and Packages
  • Import and Snapshots
  • Character Set Conversion
  • Import Modes
  • Using Import
  • Import Parameters
  • Import's Interactive Mode
  • Example Import Sessions
  • Importing Incremental, Cumulative and Complete Export Files
  • Importing Into Existing Tables
  • Generating Statistics on Imported Data
  • Importing LONGs
  • Network Considerations
  • Dropping a Tablespace
  • Reorganizing Tablespaces
  • Overriding Storage Parameters
  • Reducing Database Fragmentation
  • Export/Import Read-Only Tablespaces
  • NLS Considerations
  • Using Oracle Version 6 Export Files
  • Using Oracle Version 5 Export Files

• SQL*Loader

• SQL*Loader Concepts
  • SQL*Loader Basics
  • Direct Path Load vs. Conventional Path Load Method
  • Mapping the Data to Oracle Format
  • Logging Information
  • Prerequisites
  • Discarded and Rejected Records
  • Data Conversion and Datatype Specification

• SQL*Loader Case Studies
  • Case Study Files
  • Tables Used in the Case Studies
  • References
  • Notes
  • Running the Case Study SQL Scripts
  • Case 1: Loading Variable-Length Data
  • Case 2: Loading Fixed-Format Records
  • Case 3: Loading a Delimited, Free-Format File
  • Case 4: Loading Combined Physical Records
  • Case 5: Loading Data into Multiple Tables
  • Case 6: Loading using the Direct Path Load Method
  • Case 7: Extracting Data from a Formatted Report

• SQL*Loader Control File Reference
  • Data Definition Language (DDL) Syntax
  • Expanded Clauses and Their Functionality
  • Comments
  • Specifying Command-Line Parameters in the Control File
  • Specifying RECOVERABLE and UNRECOVERABLE
  • Specifying Filenames and Database Objects
  • Including Data in the Control File with BEGINDATA
  • Identifying Datafiles
  • Specifying READBUFFERS
  • Specifying Datafile Format and Buffering
  • Specifying the Bad File
  • Rejected Records
  • Specifying the Discard File
  • Discarded Records
  • Handling Different Character Encoding Schemes
  • Loading into Empty and Non-Empty Tables
  • Continuing an Interrupted Load
  • Assembling Logical Records from Physical Records
  • Loading Logical Records into Tables
  • Index Options
  • Specifying Field Conditions
  • Specifying Columns and Fields
  • Specifying the Position of a Data Field
  • Using Multiple INTO TABLE Statements

• Generating Data
• Specifying Datatypes
• Loading Data Across Different Operating Systems
• Determining the Size of the Bind Array
• Setting a Column to Null or Zero
• Loading All-Blank Fields
• Trimming of Blanks and Tabs
• Preserving Whitespace
• Applying SQL Operators to Fields

• SQL*Loader Command-Line Reference
  • The SQL*Loader Command Line
  • Command-Line Keywords

• SQL*Loader Log File Reference
  • Header Information
  • Global Information
  • Table Information
  • Datafile Information
  • Table Load Information
  • Summary Statistics

• SQL*Loader Conventional and Direct Path Loads
  • Data Loading Methods
  • Using Direct Path Load
  • Maximizing Performance of Direct Path Loads
  • Dropping Indexes
  • Direct Loads, Integrity Constraints, and Triggers
  • Parallel Data Loading

• NLS Utilities

• National Language Support Utilities
  • NLS Data Installation Utility
  • NLS Configuration Utility
  • NLS Calendar Utility

• Offline Verification Utility

• Offline Database Verification Utility
  • DB_VERIFY

• Summary of Changes
  • Export/Import Changes
  • SQL*Loader Changes

• Reserved Words
  • SQL*Loader Reserved Words

• Notes for DB2/DXT Users
  • SQL*Loader Extensions to the DB2 Load Utility
  • Using the DB2 RESUME Option
  • Inclusions for Compatibility
  • Restrictions
  • SQL*Loader Syntax with DB2-compatible Statements

---

Copyright © 1996 Oracle Corporation 500 Oracle Parkway, Redwood City, CA 94065

Library

Product