Oracle7 Server Utilities User's Guide

Library

Product

Contents

Title and Copyright

Preface

• 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
• Index

Next

Copyright © 1997 Oracle Corporation. All Rights Reserved.

Library Product