RE: Combination of Raw Volumes and File Systems

I have not done this but I believe an Oracle file is the same whether it is Raw or Cooked.
What you will need to copy the Raw file to UFS using some tool may be dd and then (alter database rename old-file to new-file location) after putting tablespace in offline mode.

You will need to know the exact number of blocks inside the raw file to copy.

Any corrections are welcomed,

Waleed

-----Original Message-----
From: Steven Monaghan [mailto:Steve.Monaghan_at_wcom.com] Sent: Thursday, July 06, 2000 12:27 PM
To: Multiple recipients of list ORACLE-L Subject: Combination of Raw Volumes and File Systems

Has anyone on the list created data files for a tablespace where one was on a raw volume and the other was on a file system?

We contacted Oracle support and they said it was fine, but the whole "Database Weirdness" thread that I started came into being when this change was made.

Any thoughts or experience with this would be appreciated.

Also, if you think this is a bad idea, suggestions on how to undo it would be appreciated, since data is already stored in the new data files.

Thanks in advance to the always helpful list... Steve Monaghan
WorldCom
Long Island, New York

-- 
Author: Steven Monaghan
  INET: Steve.Monaghan_at_wcom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).