Re: Tablespace on CD-Rom?

From: Kevin McHugh <Kmchugh_at_ix.netcom.com>
Date: 8 Mar 1995 04:57:02 GMT
Message-ID: <3jjdeu$gme_at_ixnews2.ix.netcom.com>


In <Henry_okeeffe.42.000F4ADC_at_inmarsat.org> Henry_okeeffe_at_inmarsat.org (Henry O' Keeffe) writes:

>
>In article <3j2g2v$d0h_at_newsbf02.news.aol.com> lmcg_at_aol.com (LMcG) writes:
>>From: lmcg_at_aol.com (LMcG)
>>Subject: Tablespace on CD-Rom?
>>Date: 1 Mar 1995 13:57:35 -0500
>
>
>>Hi,
>>We have a large data warehouse approx 12G that users want to be kept
>>online, but we are very short of diskspace. A consultant mentioned
>>creating a tablespace on CD-ROM that Oracle thinks is just on another
>>drive, and put the older information on CD. We are running 7.0.16 (soon
>>upgrading to 7.1.40, on an IBM RS6000 running AIX. Has anyone else done
>>this? Any information on setting this up would be greatly apprectiated.
>
>I'd be surprised if you could do this, as Oracle writes a sequence number to
>each datafile at intervals. If it can't do this, it get veeeeery upset.
>
>Regards,
>Henry.
>Henry_Okeeffe_at_Inmarsat.Org
>
>All opinions expressed here are not necessarily the opinions of my
>employer.
>

Version 7.1.4 of Oracle has provided for this situation by providing read-only tablespaces. For static data once it has been recorded on read-write media it can be set read-only and then written to write-once media. The one gothca is that the file is specific to a given database. This means that you can't share your favorite tablespace with your friends.

Kevin McHugh
Egghead Software Received on Wed Mar 08 1995 - 05:57:02 CET

Original text of this message