0388-0388

Previous | Table of Contents | Next

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.

Previous | Table of Contents | Next


Oracle Unleashed
Oracle Development Unleashed (3rd Edition)
ISBN: 0672315750
EAN: 2147483647
Year: 1997
Pages: 391

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net