Re: create table on tablespace

From: TurkBear <johng_at_nospam.mm.com>
Date: Tue, 18 May 1999 19:29:23 GMT
Message-ID: <3741bf0b.20320619@news.dot.state.mn.us>

BM Lam <1116-530_at_online.de> wrote:

>The following statement works:

Snip..................................

>
>create table tmp3 as (select * from tmp1) tablespace usr;
> *
>ORA-00933: SQL command not terminated properly
>
>WHY??????
>
>

The Create table as.... process is quite different in many ways,,,,

to do is that way, first alter your DEFAULT TABLESPACE to the one you want to create the table in....

' alter user your_name_here default tablespace 'new_tsname_here';

Hope it helps... Received on Tue May 18 1999 - 14:29:23 CDT