Re: help with create tablespace

From: Chris Hamilton <Christopher.H.Hamilton_at_usace.army.mil>
Date: 1997/10/06
Message-ID: <01bcd25b$8523bce0$73344b9b@hqddpc.hq.usace.army.mil>#1/1

senn <rsenn_at_capaccess.org> 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.
 

> The error messages look like insufficient disk space messages ...
 

> Also, the error messages point to line 1, which seems
> very innocuous.
>
> 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)

The problem is that you don't have a size defined for your datafile. To fix this, change line 2 to read:

  datafile 'c:\randall.sen\acct\rollback.ts' size 20m

20m in the above example indicates 20 megabytes - change it to whatever you need.

Chris

---

Chris Hamilton - Oracle Database Admin.
AVANCO Intl. / US Army Corps of Engineers Christopher.H.Hamilton_at_usace.army.mil
http://www.serve.com/cowpb/chamilton.html Received on Mon Oct 06 1997 - 00:00:00 CDT