Message-Id: <10673.121323@fatcity.com> From: "DEMANCHE Luc (Cetelem)" Date: Tue, 7 Nov 2000 17:52:47 +0100 Subject: create table This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C048DB.286F7B2A Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=20 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_001_01C048DB.286F7B2A Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable create table

Hi gurus,

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

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

What is the solution

TIA

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