Problem with a READ-ONLY device

From: Xavier Gabalda <xgabalda_at_vincle.es>
Date: Mon, 15 Mar 1999 16:03:43 +0100
Message-ID: <7cj77k$5nm$1@diana.bcn.ttd.net>

Hi.

I want to create a tablespace on a CD-ROM. These are my steps:

1. I create a tablespace with a only one datafile ( C:\TEMP\MYDATAFILE.ORA, about 600 Mb of size ).
2. I fill the datafile with data. Now I follow Oracle documentation steps using Server Manager ):
3. ALTER TABLESPACE "MYTABLESPACE" READ ONLY;
4. I copy 'MYDATAFILE.ORA' to a CD-ROM.
5. ALTER TABLESPACE "MYTABLESPACE" OFFLINE FOR RECOVER;
6. ALTER TABLESPACE RENAME FILE 'C:\TEMP\MYDATAFILE.ORA' TO 'D:\MYDATAFILE.ORA'; ( where 'D': is my CD-ROM drive )
7. ALTER TABLESPACE "MYTABLESPACE" ONLINE;

When I issue 'ALTER TABLESPACE RENAME FILE .....' I got following errors:

ORA-01511: error renaming data/log files
ORA-01141: error renaming file number 5 - 'D:\MYDATAFILE.ORA' not found
ORA-01110: data file number 5: 'C:\TEMP\MYDATAFILE.ORA'
ORA-27047: couldn''t be read header file
OSD-04006: ReadFile() failed, file couldn't be read
O/S-Error: (OS 87) wrong parameter.

Obviously, I can see both files with explorer ( C:\TEMP\MYDATAFILE.ORA and D:\MYDATAFILE.ORA ). Environment:
Oracle 8.0.4.0.0 Server
Windows NT 4.0 Server Platform. Received on Mon Mar 15 1999 - 09:03:43 CST