Re: help with create tablespace

I might be wrong, but in addition to not stateing the size of the datafile, could it be that the word 'rollback' is a reserved word in Oracle? we personally use 'RBS' as our tablespace.

Satar Naghshineh
rsenn wrote:
>
> 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 Mon Oct 06 1997 - 00:00:00 CDT