Re: help! create table as select...

create table <tablename>
tablespace <my tablespace>
storage <etc...>
as select * from mytab

Hth,

--
Sybrand Bakker, Oracle DBA
<kal121_at_yahoo.com> wrote in message news:81h5lk$240$1_at_nnrp1.deja.com...
> 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.
Received on Wed Nov 24 1999 - 11:58:17 CST