Re: help with create tablespace

I guess the problem might be related to permissions in the OS. The directory in which the datafile is being created might not have the required write permissions.

let me know if this helped.,

Chinna

rsenn <rsenn_at_capaccess.org> wrote in article <343855A5.3C11F119_at_capaccess.org>...
> Please help. I can't seem to get my 2nd tablespace created. I have
> the System tablespace, but the next one won't seem to go.
>
> I'm using a trial version of Personal Oracle for Windows 95 as a study
>
> aide to help me with classes I'm taking at Oracle Education. This
> version seems to be compatable with Oracle version 7.2.2.0.0.
>
> The error messages look like insufficient disk space messages, but I
> have 500 M free, and I defragmented my drive earlier this evening just
> to be sure I had contiguous space. I started by declaring the initial
> and next extent sizes to be 10 M and worked by way down to 2 K trying to
> see if it could be a contiguous space problem. Of course, in the low K
> range, it just can't be.
>
> Also, the error messages point to line 1, which seems
> very innocuous.
>
> My SQL statement plus the error messages follow.
>
> SQL> create tablespace rollback
> 2 datafile 'c:\randall.sen\acct\rollback.ts'
> 3 default storage
> 4 ( initial 2K
> 5 next 2K
> 6 minextents 1
> 7 -- maxextents 121 by default
> 8 pctincrease 1 )
> 9 online ;
> create tablespace rollback
> *
> ERROR at line 1:
> ORA-01119: error in creating database file
> 'c:\randall.sen\acct\rollback.ts'
> ORA-09200: sfccf: error creating file
> OSD-04002: unable to open file (OS 2)
>
>
> Thank you for your help.
>
Received on Wed Oct 08 1997 - 00:00:00 CDT