Re: create table on tablespace

Try;

create table tmp3 tablespace usr as (select * from tmp1) ;

On Tue, 18 May 1999 21:19:52 +0200, BM Lam <1116-530_at_online.de> wrote:

>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 Fri May 21 1999 - 17:11:57 CDT