Previous | Table of Contents | Next

Page 224

values for these fields if left empty. The dialog box has a number of boxes that require information. The following is a description of the boxes:

FIG. 10.1
The SQL*LOADER icon.




FIG. 10.2
The SQL*LOADER dialog box.


Page 225

The SQL*LOADER dialog box also has a number of buttons. The Browse button adjacent to the Control File and Data fields will open a file-search dialog box you can use to find the desired file you want. When the file is found, the search dialog box will return the full file address to the field.

The Defaults button will populate the optional files with default file names that match the name of the control file. The Cancel button closes the dialog box without any action occurring. The Help button displays the Oracle SQL*LOADER help. It is part of the Database Tools Users' Guide facility.

The Load button starts the execution of the load program. However, before you can start the load program, the Loader Options must be reviewed and set. This is accomplished by clicking the Advanced button, which brings up the Advanced SQL*LOADER Options dialog box, as shown in Figure 10.3.

Following are the fields in the Advanced SQL*LOADER Options dialog box. The dialog box contains a number of values. Descriptions of these values are as follows:

Page 226

After the constraints are removed, you can begin loading data beginning at record 150,001. This will save you the time that was spent on the initial loading procedure. The default is 0. The load procedure will load all rows into the table.

FIG. 10.3
The Advanced
SQL*LOADER Options,BR> dialog box.




NOTE
Table constraints were discussed in Chapter 6, "Defining the Database Objects."n

Page 227

records before terminating. Consider setting this at a low value. It's better to find out sooner than later in the long loading process that your condition logic is in error and is discarding good records early.

When you've reviewed these settings, press OK. This will return you to the SQL*LOADER dialog box. Press Load to start the loading procedure. When the load program is initiated, this brings up the SQL*LOADER Status dialog box. This screen will display error, commit, or status messages.

The loading is complete when no more messages are displayed. Press Close to close the dialog box. Figure 10.4 shows the Status dialog box.

FIG. 10.4
The SQL*LOADER Status screen.




Using the Various Load Files

The previous section discussed five files used in the loading procedure: control, data, log, bad, and discard.

The control file holds the loading instructions and will be discussed at length in the next section. The data file holds the data that will be loaded into the Oracle tables. It will be discussed under "Defining Control Files in the next section." Next you learn about the remaining three files: log, bad, and discard.

Previous | Table of Contents | Next