Re: lobs integrity check

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Apr 2002 23:50:09 +0200
Message-ID: <apc9buct64r717f7g90749sm5k38ur47mq@4ax.com>

On 10 Apr 2002 11:52:07 -0700, nikulins_at_gis.net (serge) wrote:

>Hi, How does oracle make sure that data saved to a lob column really
>is the data you intended to save without retrieving it to check? For
>example, if I save an image file, all I have is a lob locator and lob
>value, and I can get length but how do I really know that all bytes
>are there and one pixel didn't get corrupted and dropped during save
>operation. It goes for CLOBS with character data bytes as well. If
>anyone knows any documentation that describes it, it would be really
>helpful, thanks a lot.

Evidently the same question could be asked with respect to writing any byte in the database. Also evidently, you don't trust Oracle.

ROFL Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 10 2002 - 16:50:09 CDT