Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help! create table as select...
In article <81h5lk$240$1_at_nnrp1.deja.com>,
kal121_at_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.
Received on Wed Nov 24 1999 - 17:39:25 CST