HELP: Newbie SQL*Plus question

From: Don Chambers <dchamber_at_mindspring.com>
Date: 1997/04/29
Message-ID: <33658060.10807775@news.mindspring.com>#1/1

I just download Personal Oracle7. I am new to Oracle and it's been 2 years since I have done any SQL. I bought a book to help me and when I got to the first example (which uses SQL*Plus) I got an error. Below is the example and the error message:

SQL> create table customer1 (

  2      last_name   varchar2(3) not null,
  3      state_cd    varchar(2),
  4      sales       number)

  5 tablespace custspace1
  6 storage(initial 25k next 25k minextents 1);  create table customer1 (
*
ERROR at line 1:
ORA-00959: tablespace 'CUSTSPACE1' does not exist

Any help would be greatly appreciated.
Should I have created a tablespace first? If, so how - the book said nothing about it?

Thanks

   Don Received on Tue Apr 29 1997 - 00:00:00 CDT