create table on tablespace

From: BM Lam <1116-530_at_online.de>
Date: Tue, 18 May 1999 21:19:52 +0200
Message-ID: <3741BD58.F8B8A70E@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 Tue May 18 1999 - 14:19:52 CDT