From: Timo Haatainen Subject: Re: NEWBIE Q: Personal Oracle 7.3 and Tablespaces Date: 1997/12/12 Message-ID: <349142C2.7DFE@tietogroup.com>#1/1 References: <3490ad31.150319158@news.visi.net> <3490B6DB.582F@p3.net> <34910536.172856222@news.visi.net> To: DB Organization: Carelcomp Forest Oy Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server You'll need to tell the size of the datafile. Try this: CREATE TABLESPACE custspace DATAFILE 'custfile_01' SIZE 10M DEFAULT STORAGE (INITIAL 25k NEXT 25k PCTINCREASE 1 MINEXTENTS 1 MAXEXTENTS 249) ONLINE ; I'd put absolute path before filename and add file extension, so DATAFILE-clause would look like (on UNIX): DATAFILE '/xxx/yyy/custfile_01.dbf' SIZE 10M 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. > > SQL> > -------------------------------------------------------------- > > I'm using PO7.3.3 on Windows 95. The ORA-01119 error is allegedly > cause by insufficient space on the drive, but I've got 150MB+ free. > > Any more recommendations? > > db > > On Thu, 11 Dec 1997 23:00:27 -0500, Jerry Gitomer > wrote: > > >Okay, how about: > > > > CREATE TABLESPACE custspace > > DATAFILE 'custfile_01' > > DEFAULT STORAGE (INITIAL 10MB NEXT 10MB PCTINCREASE 1 > > MINEXTENTS 1 MAXEXTENTS 249) > > ONLINE; > > > >This will create a tablespace named "custspace" which will > >contain a datafile named "custfile_01" which will be located > >in the directory you were in when you you went into Oracle > >(er, well if you are using UNIX. If you are using a different > >OS I don't know where the data file will be located.) In any > >event (oh the hell with it -- I will assume that you are using > >UNIX) the data file will be 10megabytes in length (the initial > >extent size since the minimum number of extents is 1) and can > >grow to 2.49GB (since each succeeding extent will be 10MB and > >you can have a maximum of 249 extents). The PCTINCREASE value > >of 1 tells Oracle not to increase the size of each succeeding > >extent. If you specified 50 for example each succeeding extent > >would be 50% larger than the last extent added. The final > >parameter is ONLINE which tells Oracle to make it available for > >use as soon as it is created. > > > >When you press return Oracle will go out and write 10MB worth > >of something to the datafile and will then return to you. Now > >you can create the table. > > > > > >Jerry > > > > > >DB wrote: > >> > >> I'm going through _Oracle: A Beginner's Guide_ with PO7.3.3 and > >> SQL*Plus 3.3.3 on Win95. I try the following SQL statement (from > >> Chapter 5 if you're keeping track) and get an error: > >> > >> ---------------------------------------------------------- > >> Personal Oracle7 Release 7.3.3.0.0 - Production Release > >> With the distributed and replication options > >> PL/SQL Release 2.3.3.0.0 - Production > >> > >> SQL> create table customer( > >> 2 last_name varchar2(30) not null, > >> 3 state_cd varchar(2), > >> 4 sales number) > >> 5 tablespace custspace > >> 6 storage(initial 25k next 25k minextents 1); > >> create table customer( > >> * > >> ERROR at line 1: > >> ORA-00959: tablespace 'CUSTSPACE' does not exist > >> > >> SQL> > >> > >> ---------------------------------------------------------- > >> > >> For the life of me, I cannot figure out how to create a tablespace in > >> addition to the SYSTEM table space that already exists. Any ideas? > >> > >> All help is appreciated. > >> > >> db -- Timo Haatainen Carelcomp Forest Oy