Re: NEWBIE Q: Personal Oracle 7.3 and Tablespaces

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 <jgitomer_at_p3.net>
> 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