Re: NEWBIE Q: Personal Oracle 7.3 and Tablespaces

From: Robert Prendin <rprendin_at_magi.com>
Date: 1997/12/12
Message-ID: <3490b9ae.4382952@news.istar.ca>#1/1

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