Re: Oracle and WORMs

Luca Gioppo wrote:
>
> I've red that is possible to use a WORM as repository for oracle data.
> Since I have to develop an application that has to write, daily, records
> on a support that cannot be altered this seems the ideal solution.
> I'd like to know if someone has any experience to share on the subjet.

Hi Luca,

You can't use a WORM drive as a "live" tablespace that is beign updated.. The problem is that what a checkpoint occurs, Oracle needs to change the datafile's header to reflect the checkpoint. You can't modify a file header on a WORM. The only way is to completely fill your tablespace on HD and then change it to READ-ONLY and then save it the WORM. You'll need to rename all the datafiles in that tablespace to point to where you mount your WORM.

Thanks,

-- 
Stephane Lajeunesse.
Oracle DBA

Please remove nospam. from my e-mail address to reach me.