1 Reply Latest reply: Aug 31, 2012 8:06 AM by 959306 RSS

    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);
        • 1. Re: DELETE SQL Spinning
          Ashok_Ora
          If your question is related to the Oracle Database (not Berkeley DB), then please post your question to that forum. If the question is indeed related to Berkeley DB, please post a confiirmation here.

          Thanks and good luck!

          ashok