1. the table to be loaded is DEPT
	create table dept
		(deptno char(4) primary key check (DEPTNO <  22), 
		 dname char(20), 
		 loc char(20)); 

2. create an exceptions table to hold the BAD data.

	create table exception_table
		     (row_id rowid,
		      owner varchar2(30),
		      table_name varchar2(30),
		      constraint varchar2(30))

3. the control file is  something like

LOAD DATA 
   INFILE * 
   TRUNCATE 
   INTO TABLE DEPT 
   REENABLE DISABLED_CONSTRAINTS EXCEPTIONS EXCEPTION_TABLE 
   FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' 
   (DEPTNO , 
   DNAME, 
   LOC) 
   BEGINDATA 
   12,RESEARCH,"BOSTN" 
   10,"ACCOUNTING",CLEVELAND 
   11,"ART",SALEM 
   13,FINANCE,"BOSTON" 
   21,"SALES",PHILA. 
   22,"SALES",ROCHESTER 
   42,"INT'L","SAN FRAN" 

4. oracle:->sqlldr userid=mag/mag@RDtest control=DEPT.CTL direct=y

   SQL*Loader: Release 8.1.6.0.0 - Production on Tue Jul 9 14:18:45 2002

   (c) Copyright 1999 Oracle Corporation.  All rights reserved.

   Load completed - logical record count 7.                             

5. SQL> select * from dept;

DEPT DNAME                LOC
---- -------------------- --------------------
12   RESEARCH             BOSTN
10   ACCOUNTING           CLEVELAND 

11   ART                  SALEM 

13   FINANCE              BOSTON
21   SALES                PHILA. 

22   SALES                ROCHESTER 

42   INT'L                SAN FRAN

SQL> select * from exception_table;

ROW_ID             OWNER      TABLE_NAME CONSTRAINT
------------------ ---------- ---------- ------------------------------
AAAFj+AABAAAH/SAAF MAG        DEPT       SYS_C001489
AAAFj+AABAAAH/SAAG MAG        DEPT       SYS_C001489

6. check the constraints, if they were disabled..enable them.

SQL> select constraint_name, constraint_type, search_condition,
  2          status from dba_constraints where table_name = 'DEPT';

CONSTRAINT_NAME                C SEARCH_CONDITION     STATUS
------------------------------ - -------------------- --------
SYS_C001489                    C DEPTNO <  22         ENABLED
SYS_C001490                    P                      ENABLED

7. delete the BAD data.
SQL> ED
Wrote file afiedt.buf

  1* DELETE FROM DEPT WHERE ROWID IN  (select row_id from exception_table where table_name='DEPT')
SQL> /
2 rows deleted.