Re: DBMS_SQL.BIND_ARRAY: errors when specifying ranges

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 17 Jun 2003 19:56:15 +0200
Message-ID: <4fluevcvh8ukmkmpr24hue9j7quhn352mu@4ax.com>

On 17 Jun 2003 07:14:29 -0700, regiethomas_at_hotmail.com (Regi Thomas) wrote:

>
>Has anybody else had this problem? How can I get this to work? My main
>motivations are high performance and to avoid ORA-01555 'snapshot too
>old' errors.

So just make sure your rollback segments are sized appropiately, submit one update statement, commit *once* and forget about this wizardry.
You can always shrink rollback segments manually. Also when you really need advice post the update statement.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jun 17 2003 - 12:56:15 CDT