PL/SQL   «Prev  Next»

Inserting LOB data using SQL*Loader - Exercise

Objective: Load data into object tables with the LOB data type.

Exercise Scoring

This AI scored exercise is worth 10 points.

Background

Load data into object tables with the LOB data type.

Fact File

Review the fact file to find out more information about the House-O-Pets and their Oracle 8i database.
Click on the link below to view the dat a table to see the contents of the tables in the House-O-Pets database.
Data Tables

Scenario

The purpose of this exercise is to help you understand the relationship between Pet Stores and Large Objects in Oracle

Instructions

To load data into the object table, you require two main files and one log files. The two main files are a control file (ppot.ctl) and a datafile (ppot.dat). Create a control file to load data into PRODUCT_PHOTO_OBJ_TABLE.
Create a datafile to load data into PRODUCT_PHOTO_OBJ_TABLE. Run SQL*Loader to load data by passing on the following parameters: USERID/password, name for the control file, name of the log file, name of the datafile, and name of the bad file.

Hints

Set USERID = petstore/greatpets. Now answer this....

Please answer the following questions in the text box below to submit your answers to the tutor.
  1. 1. What is the requirement of a .ctl file?
  2. 2. What is the prerequisite process before loading data into LOBs using SQL*Loader?

Submitting your exercise

Type (or cut and paste) your plan into the box below to submit your answers to a tutor. Click the Submit button when finished to submit the exercise. Remember to submit all of your answers at once.