Deleting duplicate rows from table violating unique constraint

Hi,

we have a table with a UNIQUE INDEX on 8 columns

CREATE UNIQUE INDEX EOCDUT_TRX_LINES_MANU_INV_DATE ON TRX_INVOICE_DUTY_OUT

(TRX_ASSIGNED_FILE, MANUFACTURER_ID, COMM_INV_NO, DATE_INVOICE, COMM_INV_LINE_NO, TARIFF_NO, TARIFF_LINE_NO, CHARGE_INDICATOR)

/

We just loaded some data in the table using SQL LOADER and as a result there are duplicate records in the table which made

the above UNIQUE index to be in UNUSABLE state. So we need to DELETE the RECORDS that violate the UNIQUE constraint

Here is the query that gives us the records that violates the UNIQUE constraint