help with create tablespace

From: rsenn <rsenn_at_capaccess.org>
Date: 1997/10/05
Message-ID: <343855A5.3C11F119@capaccess.org>#1/1

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 Sun Oct 05 1997 - 00:00:00 CDT