Re: Using a cd for queries?

In outline:

Make the tablespace readonly.

Copy the tablespace's files to a CDROM

mount the CDROM as a file system

shutdown the database,

'hide' the original files - e.g. rename them.

mount the database, and use

    alter database rename file
to tell the database that the files for that tablespace are now on another file system.

Open the database.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

jmorley823_at_my-deja.com wrote in message <7kqvqu$ahe$1_at_nnrp1.deja.com>...
>i was told it is possible for oracle to attach to a cdrom, and be able
>to query from it. i've looked around, but i have not been able to find
>any documentation on how to do this.
>
>we have lots of archived data that is 'almost' never accessed, and
>being able to save the information on a cd would help enormously.
Received on Wed Jun 23 1999 - 11:29:37 CDT