Re: HELP: Newbie SQL*Plus question

Yes, you should :

e.g.
CREATE TABLESPACE custspace1
 DATAFILE 'C:\ORACLE\DATASPACE' SIZE 5M
 DEFAULT STORAGE (PCTINCREASE 1); see Oracle Server SQL Reference, which should be included when you downloaded Personal Oracle. Do this as 'system' or 'internal'.

Same situation as you (new to Oracle, 2 years no SQL). Met problem, found answers half an hour ago.

Stefaan

Don Chambers <dchamber_at_mindspring.com> wrote in article <33658060.10807775_at_news.mindspring.com>...
> 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 Wed May 14 1997 - 00:00:00 CDT