Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie question:

Re: newbie question:

From: BRENT DOUGLAS <BRENT.DOUGLAS_at_DAYTONOH.NCR.COM>
Date: Fri, 23 Jul 1999 15:11:03 -0400
Message-ID: <3798be8d@rpc1285.daytonoh.ncr.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US