I ran an insert statement which inserted records from one table into a table that had zero records in it. After 10 hours the number of records inserted was less than half of the total number of records to be inserted. I killed the insert process and now it is in rollback status. It is slowly removing the inserted records and will continue to do so until the table goes back to zero records. I have the database in simple mode. I don't understand why it has to rollback one record at a time. Normally when I stop an insert process it is immediate. I don't have 10 hours to wait for this rollback to finish. Is there something I can do to stop this and to avoid this problem in the future?