This discussion is archived
1 Reply Latest reply: Aug 31, 2012 6:06 AM by 959306 RSS

DELETE SQL Spinning

959306 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points