Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Readonly tablespace on cd-rom.

Readonly tablespace on cd-rom.

From: Marco Lazzeri <marco_lazzeri_at_inwind.it>
Date: Thu, 28 Mar 2002 12:48:34 +0100
Message-ID: <3CA30312.7060301@inwind.it>


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

-- 
####################################################

# Marco Lazzeri #
# ARPA-SMR - Viale Silvani, 6 - 40122 - Bologna #
# Tel.: +39 051 284591 #
# E-mail: marco_at_adgb.df.unibo.it #
# mlazzeri_at_smr.arpa.emr.it #
# melly_l_at_yahoo.com #
####################################################
Received on Thu Mar 28 2002 - 05:48:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US