Re: Tablespace on CD-Rom?
Date: 8 Mar 1995 21:02:29 GMT
Message-ID: <3jl615$n3h_at_nntp.interaccess.com>
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
>>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.
In Oracle 7.1 (or maybe 7.2? I dunno), I think it's possible to have read-only tablespaces. That might make it doable.
Your tablespace would be slow, though ...
-- -bn random_at_interaccess.com (PGP 2.6.2 public key available on request) "There is no .signature -- only ZUUL!"Received on Wed Mar 08 1995 - 22:02:29 CET