hi

how to create table space on Rawdevice ,
and what is the advantages .

pl tellme sir.

The syntax to create a DMS tablespace on raw device can be found in SQL Reference.

E.g. create tablespace ts1 managed by database using ( device '/dev/rhdisk' 20000)

There is a section documented in Administration Guide - Planning, Comparison of SMS and DMS table spaces.


Sherman