Re: Newbie SQL question

In <aak2.838971985_at_Ra.MsState.Edu>, aak2_at_Ra.MsState.Edu (Atif Ahmad Khan) writes:
>
>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 (
> last name varchar2(30) not null,
> state_cd varchar(2),
> sales number)
>
> 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
>aak2_at_ra.msstate.edu

The author is assuming that you have installed Oracle according to instructions and have already established tablespaces. If you don't specify the tablespace name on a create table it will go on the default tablespace for the user which is most likely not desirable. See Create Tablespace command if you would like to have the name match the example.

D. Scott Moyer, Jr.                        dmoyer_at_gpu.com (preferred for work)
GPU Service Corporation                dsmoyer_at_enter.net (preferred for home)