Newbie SQL question
Date: 1996/08/02
Message-ID: <aak2.838971985_at_Ra.MsState.Edu>#1/1
So I bought this "Oracle: A beinner's guide" that has a couple
of chapters on SQL. First one is "SQL 101". And the first example
is :
create table customer (
tablespace custspace storage (initial 25k next 25k minextents 1);
I have tried processing this script using sqldba/sqlplus in Personal
Oracle 7 for Windows 95 and Oracle 7 workgroup server for Solaris x86
but I get error for the last line.
Since I am very new to SQL, I am not sure if I am missing anything.
Why is author using a tablespace that does not exist ?
I would appreciate it very much if someone could throw some light
at this. Thanks very much in advance.
Atif Khan
last name varchar2(30) not null,
state_cd varchar(2),
sales number)