Home -> Usenet -> comp.databases.oracle -> NEWBIE Q: Personal Oracle 7.3 and Tablespaces

NEWBIE Q: Personal Oracle 7.3 and Tablespaces

From: DB <davibal.removethis_at_removethistoo.regent.edu>
Date: 1997/12/12
Message-ID: <3490ad31.150319158_at_news.visi.net>#1/1 







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 CET












Original text of this message