Re: BFile behaviour

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Sat, 09 Apr 2005 14:04:12 +0100
Message-ID: <4dkf515mh0pjhum9phpd600mtqls1isjfu@4ax.com>

On 7 Apr 2005 01:42:55 -0700, poisonrain0_at_gmail.com wrote:

>Hi folks...!
>could anyone throw light on how oracle handles BFiles when a
>transaction crashes (midway)?
>Does it rollback to previous state?
>Does it remove it completely?
>Does it not do anything?
>Does it do something else?

Since BFILEs are read-only, aren't the only things that change entirely inside the database, and so just subject to all the normal rules for when statements fail?

If BFILEs were writable then it'd be a danger area since the filesystem won't have the same facilities to undo or restore as the database does.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Received on Sat Apr 09 2005 - 08:04:12 CDT