I am trying to make a trigger that will delete doubles from a certain table in my Oracle database. I want to refresh the data in this table from a SQL Server table once a week. What I have is the old data in the Oracle table and then the new data from the Server table. Most of the old records and new records will be the same, so I want to eliminate the doubles.

Rather than insert everything and then delete you should insert only that which is new.