Xref: alice comp.databases.oracle.server:75457
Path: alice!news-feed.fnsi.net!cyclone.i1.net!newsfeed.enteract.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: mhauffma@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: help! create table as select...
Date: Wed, 24 Nov 1999 23:39:25 GMT
Organization: Deja.com - Before you buy.
Lines: 37
Message-ID: <81hsvd$ja1$1@nnrp1.deja.com>
References: <81h5lk$240$1@nnrp1.deja.com>
X-Article-Creation-Date: Wed Nov 24 19:39:40 1999 GMT
X-Http-User-Agent: Mozilla/4.5 [en] (WinNT; U)
X-Http-Proxy: 1.0 x21.deja.com:80 (Squid/1.1.22) for client 205.227.43.11

In article <81h5lk$240$1@nnrp1.deja.com>,
  kal121@yahoo.com wrote:
> What is the syntax to specify a tablespace and
storage clause in
> a "CREATE TABLE AS SELECT ..." statement?
>
> eg)
>
> CREATE TABLE AS SELECT * FROM my_table
> TABLESPACE my_tablespace
> STORAGE(
> INITIAL 500K
> NEXT 500
> );
>
> for some reason, the above syntax does not work,
although this is the
> correct way to specify tablespace and storage in
a regular create table
> statement.
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

create table new_table_name
as select * from my_table
TABLESPACE my_tablespace
> STORAGE(
> INITIAL 500K
> NEXT 500);


Sent via Deja.com http://www.deja.com/
Before you buy.