If direct path load causes referential integrity to be violated, then the data will be loaded but xxx_CONSTRAINTS.STATUS changes from 'ENABLED' to 'DISABLED', value of VALIDATED column from 'VALIDATED' to 'NOT VALIDATED'. If there's an on-insert trigger on a table and direct path load (sqldr direct=true) is done to load data into it, the trigger won't be fired but xxx_TRIGGERS.STATUS stays as 'ENABLED'. Other notes: * Direct path insert (insert /*+ append */) does fire the trigger. * ALTER TABLE DISABLE TABLE LOCK will prevent sqlldr direct path load, as well as setting DML_LOCKS to 0 (but the latter is a very bad idea!).