Re: newbie question:

that IS the problem, you have to create the tablespace first....

that syntax can be more complicated, but it's very similar -

CREATE TABLESPACE cust DATAFILE 'datafile1' SIZE 10M;

is a pretty simple example.... i dont have good luck w/ prior commands, but i think you can load something like DOSKEYS and use that...

brent

>SQL> create table customer(
> 2 last_name varchar2(30) not null,
> 3 state_cd varchar(2),
> 4 sales number)
> 5 tablespace custspace
> 6 storage(initial 25k next 25k minextents 1);
>
>The book says that I am supposed to get a "Table Created" message but I
>get somehing like "no tablespace custspace created".

>Also, when running Sql*Plus, is it possible for me to scan through past
>commands.. what I mean is that is there some kind of history like the
>bash shell in UNIX wherein I can key through the past commands issued?
Received on Fri Jul 23 1999 - 14:11:03 CDT