Re: HELP: Newbie SQL*Plus question

Don Chambers wrote:

> 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

 Yes. Create the tablespace first. Use the CREATE TABLESPACE command.

Oh, and GET ANOTHER BOOK! :-)

Try Oracle DBA Handbook, Oracle press. Very good intro book.

Steve Phelan. Received on Wed Apr 30 1997 - 00:00:00 CDT