Re: Non-transactional tablespaces

From: Mark Wagoner <mwagoner_at_no.spam.iac.net>
Date: Fri, 20 Aug 1999 19:18:32 GMT
Message-ID: <37bda89b.595706791@news.iac.net>

On Fri, 20 Aug 1999 14:22:07 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>Is there any strong objection to storing them
>as BFILEs instead of BLOBs if they are
>effectively read-only ?
>
>--

We have tried that and it does work, although it is a little faster accessing directly from the BLOB. The other problem we had was maintaining the pointers between the database and the external files. We had a customer who needed disk space, didn't know what all these 70-100K files were, so he deleted them. Of course within the database all the references still existed.

Granted, this could be chalked up to stupid-user-error, but since we are going back and trying to find the best solution to this problem I thought I would explore the non-transactional tablespace route. --
Mark Wagoner
To reply, remove no.spam from my e-mail address Received on Fri Aug 20 1999 - 14:18:32 CDT