Re: Non-transactional tablespaces

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 20 Aug 1999 14:22:07 +0100
Message-ID: <935160762.10189.0.nnrp-08.9e984b29@news.demon.co.uk>

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

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Mark Wagoner wrote in message <37bd4d34.572307094_at_news.iac.net>...
>We are currently storing TIFF images as BLOBs in an 8.0.5 database.
>The problem we have is, because the TIFFs are so large, the
>transactions are also large so a lot of archive logs are being
>generated. On the average we are cutting a 500M archive log every 45
>minutes or so.
Received on Fri Aug 20 1999 - 08:22:07 CDT