Re: a question about create table ?

From: Peter Whyte <zephyr_at_uq.net.au>
Date: 20 Jun 1998 12:59:52 GMT
Message-ID: <01bd9c4b$19a0f0e0$a014a8c0@sux6000>

Raymond Du <rdu_at_idmcorp.com> wrote in article <6me3ma$p0i_at_nntp02.primenet.com>...
>create table newtable as
> 2 select * from orgtable
> 3 TABLESPACE TABLESPACE_02;
> TABLESPACE TABLESPACE_02
> *
> ERROR at line 3:
> ORA-00933: SQL command not properly ended
>
> I want to create a table by using a select statement and using
TABLESPACE_02
> tablespace.
>

Oops, got it wrong :(
Apparently

create table newtable
tablespace TABLESPACE_02
as select * from orgtable;

will do the trick. Received on Sat Jun 20 1998 - 07:59:52 CDT