Lesson 16 - Loading and Reorganizing Data

Table of Contents

Loading and Reorganizing Data

Objectives

Overview

Using Direct-Load Inserts

Parallel Direct-Load Insert

SQL*Loader

Conventional and Direct Loads

Comparing Direct and Conventional Path Loads

Parallel Direct Loads

Using SQL*Loader

SQL*Loader: Input Files

Log File Contents

SQL*Loader: Other Output Files

SQL*Loader: Usage Guidelines

SQL*Loader: Troubleshooting

Moving Data Using EXP/IMP

Uses of Export and Import

Export Modes

Conventional/Direct Path Export

Using Export

Using Import

Import Behavior

Guidelines on the Usage of Export and Import

NLS Considerations in Export and Import

Summary

Email: melody@ecst.csuchico.edu

Home Page: http://www.ecst.csuchico.edu/~melody

Download presentation source