Oracle SQL*Loader uses two load types: Conventional path (uses SQL INSERT statements, slower but more compatible) and Direct path (bypasses SQL engine, writes directly to data blocks, much faster). 'Indirect' and 'Insert' are not valid SQL*Loader load type categories.