I execute the following SQL and it just sits there and spins. Changing the DELETE to SELECT returns rows. Any suggestions. Originally this was written to delete rows against a DB2 table. Trying to get them to work against ORACLE.
DELETE FROM FTELOG.TRANSFER WHERE TRANSFER_ID IN (SELECT t.TRANSFER_ID FROM FTELOG.TRANSFER_EVENT te, FTELOG.TRANSFER t WHERE t.COMPLETE_ID = te.ID AND te.ACTION_TIME < SYSDATE - 90);