Re: Terrabyte Databases

From: Neil <plums_at_bigfoot.com>
Date: Thu, 25 Nov 1999 09:01:29 -0000
Message-ID: <81itva$30e$1@pheidippides.axion.bt.co.uk>

Presumably then, the bfiles are backed up as per any other O/S file, and only if they have been changed ?
Using the Image Cartridge, through what interface are the bfiles quieried and displayed ? I know you can use sql & pl/sql to query the table that has a type of ORDIMGF, but what would actually display this image ?

Many thanks

Neil

Jonathan Lewis wrote in message
<943479004.20293.1.nnrp-01.9e984b29_at_news.demon.co.uk>...
>
>And why use a database for images anyway ?
>Unless you are really interested in read-consistent
>queries and some strange transactional activity on
>images you might as well store them as O/S files
>and use the BFILE method. Its quicker, cheaper
>and less hassle.
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
>Connor McDonald wrote in message <383BDE7B.2B96_at_yahoo.com>...
>>Neil wrote:
>>>
>>> We are looking at a system that would hold > 1 TB data mostly in the
form
>of
>>> images, that would be viewable via the internet.
>>>
>>
>>1. What backup methodology do you use / suggest
>>
>>Don't. That is, put as much into read-only tablespaces as possible and
>>backup just the rest. Otherwise, start saving for lots of disk for
>>mirror/mirror-break concepts, or some heavy duty storagetek tape drives.
>>
>
>
>
Received on Thu Nov 25 1999 - 03:01:29 CST