Re: Very long query

From: Rolf Hauck <Rolf.Hauck_at_datenrevision.de>
Date: Thu, 10 Dec 1998 07:55:37 +0100
Message-ID: <366F7069.3134684F@datenrevision.de>

Did you check for locks on your table?
Why don't you commit inside the loop?

Rolf

Zachary Agatstein schrieb:
>

...
> Why if I can successfully delete 1000 records, I cannot consecutively delete
> all of them in 1000-record chunks?
>
> Thanks
>
> Zach Agatstein
Received on Thu Dec 10 1998 - 00:55:37 CST

This message: [ Message body ]
Next message: Rolf Hauck: "Re: How to use Sql*plus cross Fairwall"
Previous message: Rolf Hauck: "Re: Help needed in Unix Shell Scripts"
In reply to: Zachary Agatstein: "Very long query"
Next in thread: Thanassis M Mylonas: "Re: Very long query"
Reply: Thanassis M Mylonas: "Re: Very long query"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US