Re: Problem creating a tablespace using Personal Oracle7 trial

From: Eric Palmer <efp_at_etechinc.com>
Date: 1996/07/07
Message-ID: <31dfccb3.48340029_at_news.mindspring.com>#1/1

On 6 Jul 1996 23:25:38 GMT, fern_at_aa.net (Fernando Luna) wrote:

>SQL> create tablespace proda datafile 'c:\orawin\plus31\proda.ora';
>create tablespace proda datafile 'c:\orawin\plus31\proda.ora'
>*
>ERROR at line 1:
>ORA-01119: error in creating database file 'c:\orawin\plus31\proda.ora'
>ORA-09200: sfccf: error creating file
>OSD-01002: unable to open file (OS 2)
>

Boy I beat my head raw on this one silly - on NT Oracle Workgroups

You need to specify a size for the file like

create tablespace proda datafile 'c:\orawin\plus31\proda.ora' size 10M;
*** 10M for 10 MegaBytes ***

That should do the trick.

Good Luck

---

SERIS - SouthEast Regional Internet Society Enhancing Your Time On-Line
http://www.seris.org/

---

Eric F. Palmer
770.825.0535 Voice - 770.825.0796 Fax
http://www.etechinc.com/ *** Standard Disclaimer ***

---

Received on Sun Jul 07 1996 - 00:00:00 CEST