Dynamic Performance (V$) Views, 79 of 179

V$LOADTSTAT

SQL*Loader statistics compiled during the execution of a direct load. These statistics apply to the current table. Any SELECT against this table results in "no rows returned" since you cannot load data and do a query at the same time.

Column Datatype Description

LOADED

NUMBER

Number of records loaded

REJECTED

NUMBER

Number of records rejected

FAILWHEN

NUMBER

Number of records that failed to meet any WHEN clause

ALLNULL

NUMBER

Number of records that were completely null and were therefore not loaded

LEFT2SKIP

NUMBER

Number of records yet to skip during a continued load

PTNLOADED

NUMBER

Number of records loaded PTN

Column	Datatype	Description
`LOADED`	`NUMBER`	Number of records loaded
`REJECTED`	`NUMBER`	Number of records rejected
`FAILWHEN`	`NUMBER`	Number of records that failed to meet any WHEN clause
`ALLNULL`	`NUMBER`	Number of records that were completely null and were therefore not loaded
`LEFT2SKIP`	`NUMBER`	Number of records yet to skip during a continued load
`PTNLOADED`	`NUMBER`	Number of records loaded PTN