Re: create table on tablespace

The tablespace part has to be before the 'as select';

create table tmp3
tablespace usr
as select * from tmp1;

--
Terry Dykstra
Canadian Forest Oil Ltd.
BM Lam <1116-530_at_online.de> wrote in message <3741BD58.F8B8A70E_at_online.de>...
>The following statement works:
>
>create table tmp1 (c1 integer) tablespace usr;
>
>The following statement works as well:
>
>create table tmp2 as (select * from tmp1) ;
>
>But the following one does NOT:
>
>create table tmp3 as (select * from tmp1) tablespace usr;
>
>The error msg says (translated from german, the real wording in an
>english environment may be different:
>
>create table tmp3 as (select * from tmp1) tablespace usr;
> *
>ORA-00933: SQL command not terminated properly
>
>WHY??????
>
>
>
Received on Wed May 19 1999 - 13:48:46 CDT