Re: switch from file system to raw device

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Wed, 15 Sep 2004 15:09:07 GMT
Message-ID: <nWY1d.28783$KU5.28403@edtnps89>

Howard J. Rogers wrote:

>> However creating a new tablespace that has datafiles in raw partitions,
>> moving the tables, and dropping the original tablespace is always a
>> possibility (except for system tablespace).

>
> Given he's on 8.0, that's going to be an extremely long-winded way to go
> about this (no 'alter table X move', for example).

export
create tablespace(s) raw
drop tablespace(s) cooked
import

didn't mean to imply using the "alter table ... move", meant "move using some tool"

moot point - i agree with your other comments Received on Wed Sep 15 2004 - 10:09:07 CDT