Re: Tablespace on CD-Rom?

Haven't done it yet, but one of the new goodies is supposed to be a READONLY Tablespace. I assume it would have to be WRITEABLE at some point or else how did the data get there in the first place, but that's a detail you'll probably cross before me!

I hope this point you in the right direction.

Sincerely,

Martin Farber
Independent Oracle Consultant "A Jack of all trades and a slave to one."

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1B-23
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216

In article 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.
Received on Wed Mar 08 1995 - 03:11:04 CET