I have just confirmed that all the indices have been dropped on the tables before the load started thank you Gene Gurevich Oracle MySQL Operations - OMO 224-405-4079 -- //www.freelists.org/webpage/oracle-l