Fyodor Krasnov wrote:
>
> Hi !
>
> Does anybody know HOW create tablespace on rawdevice?
>
> I'm on Solaris 2.51
> Oracle 7.3.2.1
>
> --
> S.y. Fyodor Krasnov
HI,
Use the unix link command (ln) to create a symbolic link name to the raw
device. Then use the create tablespace tablespace_name datafile
'link_file_name' size nn.
If you set the raw device size to say 500mg the size parameter has to be
2 blocks less than the size of the device.
500mg x1024x1024=524288000 Therefore, if blocksize is 4096 subtract
2x4096 0r 8192 from 524288000 to get 524279808 for the value to use in
the size parameter of the create statement.
Hope this helps.
Dick
Received on Thu Aug 14 1997 - 00:00:00 CDT
