Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Validating and Selectively Loading Data

Chapter 7. Validating and Selectively Loading Data

SQL*Loader can create two types of output data files during a load: the bad file and the discard file. The bad file is where SQL*Loader writes input records that cause errors. The discard file is where SQL*Loader writes records that do not match conditions that you specify in your LOAD statement. We first mentioned these files in Chapter 1. In this chapter, we'll delve more deeply into the use of the bad and discard files.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint