Re: 01555 and select statement

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 May 2006 23:08:45 +0200
Message-ID: <mdl462d15ufkss8sdpljj4vg8i7odjf15u@4ax.com>

On 10 May 2006 13:58:06 -0700, niy38_at_hotmail.com wrote:

>if drop the incremental commits, I worry the udno segment will increase
>a lot,
>and ora-01555 still occur possibly.

This is the common fairy tale people insisting on incremental commit always come up with. If you don't have sufficient disk space *BUY* it. Disk is cheaper than your overtime!!!

Ora-1555 won't occur if you move the commit outside the loop: read the literature and stop worrying. Just search on ora-1555 on this forum on you will find a thread with all the gory details why you shouldn't commit in a loop.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed May 10 2006 - 16:08:45 CDT