File permissions upon datafile dirs?

Hey, :-)

    I am trying to create a datafile in a directory and I keep experiencing this problem:

>>

SQL> CREATE TABLESPACE snoopdogg DATAFILE '/mydir/oracleowned/snoopdogg.dbf' SIZE 5M AUTOEXTEND ON NEXT 512K MAXSIZE UNLIMITED online ;
CREATE TABLESPACE snoopdogg DATAFILE '/mydir/oracleowned/snoopdogg.dbf' SIZE 5M AUTOEXTEND ON NEXT 512K MAXSIZE UNLIMITED online *
ERROR at line 1:
ORA-01157: cannot identify data file 48 - file not found ORA-01110: data file 48:
'/mydir/oracleowned/snoopdogg.dbf'
<<

Directory permissions:
>>

drwxrwxrwx   3 oracle   dba           512 Apr 20 13:36 oracleowned/
drwxrws---   5 sim      p002          512 Apr 19 17:03 mydir/

What are the rules for permissions upon datafile dirs?

Oracle ver: 8.0.3
OS : solaris

Many Thanks
S. Received on Tue Apr 20 1999 - 01:01:49 CDT