1 Reply Latest reply on Aug 31, 2012 1:10 PM by Ashok.Ora-Oracle

    DELETE SQL Spinning

    959306
      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.

      Thanks, bobbee

      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);