Oracle8i Utilities
Release 8.1.5

A67792-01

Library

Product

Contents

Index

Prev Next

7
SQL*Loader: Log File Reference

When SQL*Loader begins execution, it creates a log file. The log file contains a detailed summary of the load.

Most of the log file entries will be records of successful SQL*Loader execution. However, errors can also cause log file entries. For example, errors found during parsing of the control file will appear in the log file.

This chapter describes the following log file entries:

Header Information

The Header Section contains the following entries:

For example:

SQL*Loader: Version 8.0.2.0.0 - Production on Mon Nov 26...
Copyright (c) Oracle Corporation...

Global Information

The Global Information Section contains the following entries:

If the data is in the control file, then the data file is shown as "*".

For example:

Control File:     LOAD.CTL
Data File:        LOAD.DAT
  Bad File:       LOAD.BAD
  Discard File:   LOAD.DSC

 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     64 rows, maximum of 65536 bytes
Continuation:   1:1 = '*', in current physical record
Path used:      Conventional

Table Information

The Table Information Section provides the following entries for each table loaded:

For example:

Table EMP, loaded from every logical record.
Insert option in effect for this table: REPLACE

   Column Name                Position   Len  Term Encl Datatype
--------------------------------------   ---  ---- ---- ---------
   EMPNO                           1:4     4            CHARACTER
   ENAME                          6:15    10            CHARACTER
   JOB                           17:25     9            CHARACTER
   MGR                           27:30     4            CHARACTER
   SAL                           32:39     8            CHARACTER
   COMM                          41:48     8            CHARACTER
   DEPTNO                        50:51     2            CHARACTER

Column EMPNO is NULL if EMPNO = BLANKS
Column MGR is NULL if MGR = BLANKS
Column SAL is NULL if SAL = BLANKS
Column COMM is NULL if COMM = BLANKS
Column DEPTNO is NULL if DEPTNO = BLANKS

Datafile Information

The Datafile Information Section appears only for datafiles with data errors, and provides the following entries:

For example:

Record 2: Rejected - Error on table EMP.
ORA-00001:  unique constraint <name> violated
Record 8: Rejected - Error on table EMP, column DEPTNO.
ORA-01722:  invalid number
Record 3: Rejected - Error on table PROJ, column PROJNO.
ORA-01722:  invalid number

Table Load Information

The Table Load Information Section provides the following entries for each table that was loaded:

For example:

The following indexes on table EMP were processed:
Index EMPIX was left in Direct Load State due to
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Table EMP:
7 Rows successfully loaded.
2 Rows not loaded due to data errors.|
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.

Summary Statistics

The Summary Statistics Section displays the following data:

For example:

Space allocated for bind array:              65336 bytes (64 rows)
Space allocated for memory less bind array:  6470 bytes

Total logical records skipped:          0
Total logical records read:             7
Total logical records rejected:         0
Total logical records discarded:        0

Run began on Mon Nov 26 10:46:53 1990
Run ended on Mon Nov 26 10:47:17 1990

Elapsed time was:     00:00:15.62
CPU time was:         00:00:07.76

Oracle Statistics Reporting to the Log

Oracle statistics reporting to the log file differs between different load types:

Statistics for Loading a Single Partition

Statistics for Loading a Table

For conventional loads and direct loads of a non-partitioned table, statistics reporting is unchanged from Oracle7.

If media recovery is not enabled, the load is not logged. That is, media recovery disabled overrides the request for a logged operation.

New Command-line Option: silent=partitions|all

The command-line option, silent=partitions, disables output of the per-partition statistics section to the log file for direct loads of a partitioned table.

In Oracle8i, the option silent=all includes the partitions flag and suppresses the per-partition statistics.





Prev

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index