From: rprendin@magi.com (Robert Prendin)
Subject: Re: NEWBIE Q: Personal Oracle 7.3 and Tablespaces
Date: 1997/12/12
Message-ID: <3490b9ae.4382952@news.istar.ca>#1/1
References: <3490ad31.150319158@news.visi.net>
NNTP-Posting-Date: Thu, 11 Dec 1997 23:16:28 EST
Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server



It means exaclty what it says that the tablespace you are attempting
to store the data in does not exist. Either create it or select a
valid tablespace by :

select tablespace_name from dba_tablespaces;

try not to store this stuff in the system or rollback tablespaces...

you will probably have a temp or user_data tablespace, those would 
be fine in which case you could simple say:

SQL> create table customer(
  2        last_name  varchar2(30) not null,
  3        state_cd   varchar(2),
  4        sales      number)
  5    tablespace user_data
  6    storage(initial 25k next 25k minextents 1);

good luck

davibal.removethis@removethistoo.regent.edu (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