Re: NEWBIE Q: Personal Oracle 7.3 and Tablespaces

I've never created a tablespace/datafile without the size parameter on the data file. ( I also always fully qualify the path) like

 CREATE TABLESPACE custspace
  DATAFILE 'c:\orawin95\database\custfile_01.dbf' SIZE 10M   DEFAULT STORAGE (INITIAL 25k NEXT 25k PCTINCREASE 1    MINEXTENTS 1 MAXEXTENTS 249)
  ONLINE DB wrote:

> Thank you so much for the response. Well, here's what it spit back
> when I tried your suggestion (I changed the 10MB in DEFAULT STORAGE to
>
> 25k):
>
> --------------------------------------------------------------
> SQL>
> 1 CREATE TABLESPACE custspace
> 2 DATAFILE 'custfile_01'
> 3 DEFAULT STORAGE (INITIAL 25k NEXT 25k PCTINCREASE 1
> 4 MINEXTENTS 1 MAXEXTENTS 249)
> 5* ONLINE
> CREATE TABLESPACE custspace
> *
> ERROR at line 1:
> ORA-01119: error in creating database file 'custfile_01'
> ORA-09200: sfccf: error creating file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
>

%<snip> Received on Fri Dec 12 1997 - 00:00:00 CET