Re: Error creating TABLESPACE using raw device on Solaris 8.

"Francesco" <francesco.cantisano_at_tin.it> wrote in message news:aqvr7s$c96pr$1_at_ID-74096.news.dfncis.de...
> Hi to all,
> we are trying to create a tablespace using a raw device.

Masochists, huh?

> The sysadm as created some raw devices (1Giga each)
> e.g. /dev/rdsk/c0t0d0s4
> And I have created with the oracle user some symbolic links to these
devices
> in
> /store0/oradata/PGV880
> so, I see with an ls -la
> lrwxrwxrwx 1 oracle dba 18 Nov 12 14:33 PGV880_data4_1000M.dbf ->
> /dev/rdsk/c0t0d0s4
> But if I try to use one of these files
> create tablespace raw_tbs datafile
> '/store0/oradata/PGV880/PGV880_data4_1000M.dbf' size 1000M;
>

And what happens if you address the raw device directly? IE, 'create tablespace blah blah blah '/dev/rdsk/c0tetcetcetc'??

Regards
HJR
> I get
>
> ERROR at line 1:
> ORA-01119: error in creating database file
> '/store0/oradata/PGV880/PGV880_Data4_1000M.dbf'
> ORA-27040: skgfrcre: create error, unable to create file
> SVR4 Error: 13: Permission denied
>
> Can someone help us to understand what is wrong?
> Thanks,
> Francesco
>
>
Received on Thu Nov 14 2002 - 04:53:38 CST