Oracle Development Unleashed (3rd Edition)

Page 388

Listing 16.9. parfile example.

SQLLOAD parfile=weekly.par WEEKLY.PAR userid = scott/tiger control = weekly.ctl log = weekly.log errors = 25 direct = true

Command-line arguments specified in the control file or a parfile can still be overridden from the command line.

Summary

You have probably noticed by now that SQL*Loader is a very robust utility. You can use SQL*Loader to load very small or very large amounts of data into an Oracle database. SQL*Loader supports a wide variety of external files and gives you a great deal of flexibility in loading your tables. With the parallel option, SQL*Loader is ready to support your data warehousing applications.