Re: Readonly tablespace on cd-rom.

From: Jarett <nospam_at_uglyduck.com>
Date: Sat, 30 Mar 2002 05:32:10 -0500
Message-ID: <sv4baussit3sn315addhps4bcdhhti6sdl@4ax.com>

Read metalink articles for info on RO on CDROMS: Note:124939.1
Subject: ReadOnly-Offlined Tablespaces and Controlfile Recreation

Note:33402.1
Subject: Read-Only Tablespaces

Jarett

On Thu, 28 Mar 2002 12:48:34 +0100, Marco Lazzeri <marco_lazzeri_at_inwind.it> wrote:

>Hi oracle experts,
>has anybody put a tablespace on a cd-rom?
>I have an oracle 8.1.6 running on an alpha system (Unix Tru64 4.0G) and
>I have put a tablespace on a cd-rom, but when I try a select command on
>the table which is on that tablespace I get an ORA-01157 followed by an
>ORA-01110 and an ORA-27086. Besides the operating system gives the
>following error:
>Error 45: Operation not supported on socket
>Additional information: 8
>
>It seems that the operating system is trying to pwrform some writing and
>locking procedures on the mounted cdrom which (obviously) read-only.
>
>Thank you in advance,
>Marco
Received on Sat Mar 30 2002 - 04:32:10 CST