Tuesday, September 4, 2007

Using the SQL*Loader in Oracle 10g

Using the SQL*Loader in Oracle 10g

Learning objective

After completing this topic, you should be able to load data using the SQL*Loader.

Exercise overview

In this exercise, you're required to use the SQL*Loader to load data into a table.

This involves the following task:

  • performing a direct-path load

Task 1: Load data into a table

You have logged onto Enterprise Manager, and you are currently in the Home page. Access the Load Data from File wizard and configure a load to execute immediately. Use the /home/oracle/product/10.1.0/oradata/orcl1/load1.ctl control file, which is designed to load data into the PRODUCT_MASTER table.

Specify that a bad file called /home/oracle/product/10.1.0/oradata/orcl1/bad1.dat should be generated to store records with errors. The load should consist of direct saves of data blocks into the table. View each page of the wizard before running the load.

Steps list
1. Click the Maintenance link
2. Click the Load Data from File link
3. Type /home/oracle/product/10.1.0/oradata/orcl1/load1.ctl
4. Click Next
5. Click Next
6. Select Direct Path (faster)
7. Click Next
8. Select the Generate bad file where records which contain errors are stored checkbox
9. Type /home/oracle/product/10.1.0/oradata/orcl1/bad1.dat
10. Click Next
11. Click Next
12. Click Submit Job

No comments: