Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> help! create table as select...

help! create table as select...

From: <kal121_at_yahoo.com>
Date: Wed, 24 Nov 1999 17:01:44 GMT
Message-ID: <81h5lk$240$1@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:01:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US