NEWBIE Q: Personal Oracle 7.3 and Tablespaces

From: DB <davibal.removethis_at_removethistoo.regent.edu>
Date: 1997/12/12
Message-ID: <3490ad31.150319158@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 CST