Re: Can Oracle access CD-rom as a table?

kgrigg_at_acxiom.com wrote:
: Now, I had heard this might be possible...can you have files on a CD-Rom
: and have Oracle access them as tables? We are going to be getting a lot
: of information on a monthly basis on CD-Rom and rather than INSERT/DELETE
: to tables on HD's, could I just map Oracle to point to the disk drives?
: A couple of questions...

Sort of. You can't just connect any old CD-ROM to Oracle; it doesn't work that way. There is one way to use CD-ROM media as part of a database, but I doubt that it is what you are looking for.

Here's the deal. Create a tablespace using a 650mb datafile. Create tables and indexes in that tablespace. When all the data you want is in the tablespace, you issue the command "alter tablespace (tablespace_name) read only;"

Then you can copy the datafile to a CD-ROM, and tell Oracle where it has moved to by doing something like "alter database rename file '/data1/ro_data_file.dbf' to '/cdrom/ro_data_file.dbf';".

This doesn't sound as though it's what you're interested in, but perhaps it will be useful anyway.

There may be other ways to do it using one of the server options. I don't know of any, though.

-- 
-bn
random_at_interaccess.com	(PGP 2.6.2 public key available on request)
"There is no .signature -- only ZUUL!"