Re: RawDevice??

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1997/08/20
Message-ID: <01bcad71$f09900c0$3f050059@billyv.vslabs.co.za>#1/1

Fyodor Krasnov <fyodor_at_aha.ru> wrote in article <33F2D816.3BB9DAB_at_aha.ru>...
> Does anybody know HOW create tablespace on rawdevice?
>
> I'm on Solaris 2.51
> Oracle 7.3.2.1

Exactly as you would create a normal tablespace. The only difference is that instead of specifying a filesystem and filename, you specify the device name (as in /dev) of the raw device.

Oh yes, in our case we could not allocate 100% of the raw device space to Oracle. It seems that there are overheads that require some of the raw space. For our 1GB raw devices we've allocated 990 MB to the Oracle tablespace. Also remember that allocations are once off. You can not extended it afterwards - like slippery fingers that allocated only 1 MB of a 1GB raw disk to a tablespace. <grin>

We had to wait for more than a month before we could drop that tablespace, correct the CREATE TABLESPACE entry for that device, re-create it and reload the data...

regards,
Billy Received on Wed Aug 20 1997 - 00:00:00 CDT