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