Re: How to convert RAW <-> File datafiles of tablespace?

"mako" <makoml_at_jcom.home.ne.jp> wrote in news:_saq7.1575$kn.190961_at_news1.rdc1.ky.home.ne.jp:

> Hello everybody,
> Is it possible to convert filesystem-based (cooked) tablespace
> datafiles to raw-based datafiles?

...
> dd if=/oradata/data001.dbf bs=16k of=/dev/vg01/rdata001
>

Not too familiar with HP 64bit, but what you did should work.

A couple of things to check. You did do this while the database was down, right?

Second. You did perform and alter database rename datafile ... while the database was in mount only.

There are slightly different ways, but there are two issues.

1. the datafile can't change during the copy in any way.
2. you have to make sure that you have all rights to the device.

The next issue is that most systems have an area in a raw/clustered raw partition that is a reserved area. This in most cases is actually protected from harm, but that may be your issue.

-- 
Robert Fazio
Senior Technical Advisor
dbabob_at_yahoo.com