Re: NEWBIE Q: Personal Oracle 7.3 and Tablespaces

From: DB <davibal.removethis_at_removethistoo.regent.edu>
Date: 1997/12/12
Message-ID: <34910536.172856222@news.visi.net>#1/1

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?

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
Received on Fri Dec 12 1997 - 00:00:00 CST