Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Combination of Raw Volumes and File Systems
This is a multi-part message in MIME format.
--------------953071895A04E517225EA898 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
"Khedr, Waleed" wrote:
> I have not done this but I believe an Oracle file is the same whether it is
> Raw or Cooked.
NO, this is not correct. My personal experience say - db may have both raw and common FS files, but you can transfer data berween them only using IMP/EXP Vadim
>
> 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-----
> Sent: Thursday, July 06, 2000 12:27 PM
> To: Multiple recipients of list ORACLE-L
>
> 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).
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.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).
--------------953071895A04E517225EA898
Content-Type: text/x-vcard; charset=us-ascii;
name="dim.vcf"
Content-Transfer-Encoding: 7bit Content-Description: Card for Vadim Gorbunov Content-Disposition: attachment;
begin:vcard
n:Gorbunov;Vadim
tel;work:(095)737-3533
x-mozilla-html:FALSE
url:www.protek.ru org:Protek;IT adr:;;;Moscow;;;Russia