Re: create table on tablespace

From: Gerard M. Averill <e-mail.address_at_my.sig>
Date: Tue, 18 May 99 20:43:25 GMT
Message-ID: <7hsj37$vrk$1@news.doit.wisc.edu>

In article <3741BD58.F8B8A70E_at_online.de>, BM Lam <1116-530_at_online.de> wrote:
>Dies ist eine mehrteilige Nachricht im MIME-Format.
>--------------7B5CD026ABF2619798909446
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>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;
>

<snip>

Your TABLESPACE clause must come before the subquery, e.g.:

        create table tmp2
        tablespace usr
        as
        select * from tmp1

Hope this helps.
Gerard

---

Gerard M. Averill, Researcher
CHSRA, University of Wisconsin - Madison GAverill<at>chsra<dot>wisc<dot>edu Received on Tue May 18 1999 - 15:43:25 CDT