Re: Newbie SQL question

Atif Ahmad Khan wrote:
>
> 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 following query should tell you what tablespaces exist. It assume you are signed in as system or sys.

select tablespace_name
from sys.dba_tablespaces;

Good Luck. Received on Fri Aug 02 1996 - 00:00:00 CEST