Message-Id: <10673.121344@fatcity.com> From: "Tom Pall" Date: Tue, 7 Nov 2000 13:14:55 -0600 Subject: Re: create table This is a multi-part message in MIME format. ------=_NextPart_000_12EE_01C048BC.B8B009D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable create table Create table table2 tablespace tools (storage parameters ...) as = (select * from table1; ----- Original Message -----=20 From: DEMANCHE Luc (Cetelem)=20 To: Multiple recipients of list ORACLE-L=20 Sent: Tuesday, November 07, 2000 11:40 AM Subject: create table Hi gurus,=20 I have no problem with this : =20 create table table1 (a number) tablespace tools=20 But I can't do this :=20 create table table2 as (select * from table1) tablespace tools = What is the solution=20 TIA=20 -----------------=20 Luc Demanche=20 CETELEM=20 T=E9l.: 01-46-39-14-49=20 Fax : 01-46-39-59-88=20 ------=_NextPart_000_12EE_01C048BC.B8B009D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable create table
 
 
Create table table2 tablespace  tools (storage = parameters=20 ...) as (select * from table1;
----- Original Message -----
From:=20 DEMANCHE Luc (Cetelem)
To: Multiple recipients of list ORACLE-L =
Sent: Tuesday, November 07, = 2000 11:40=20 AM
Subject: create table

Hi gurus,

I have no problem with this : =20
        create table table1 (a number) tablespace tools

But I can't do this :=20
        create=20 table table2 as (select * from table1) tablespace tools

What is the solution

TIA

-----------------
Luc Demanche
CETELEM=20
T=E9l.: 01-46-39-14-49 =
Fax : 01-46-39-59-88