Re: NEWBIE Q: Personal Oracle 7.3 and Tablespaces

From: Greg Kainz <gkainz_at_orapro.com>
Date: 1997/12/12
Message-ID: <3491AC43.B0AF58ED@orapro.com>#1/1

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 CST