Logical Records

SQL*Loader organizes the input data into physical records, according to the specified record format. By default a physical record is a logical record, but for added flexibility, SQL*Loader can be instructed to combine several physical records into a logical record.

SQL*Loader can be instructed to follow one of the following logical record-forming strategies:

• Combine a fixed number of physical records to form each logical record.

• Combine physical records into logical records while a certain condition is true.

  See Also:

  • "Assembling Logical Records from Physical Records"

  • Case study 4, Loading Combined Physical Records (see "SQL*Loader Case Studies" for information on how to access case studies)