Message-Id: <10674.121407@fatcity.com> From: "DEMANCHE Luc (Cetelem)" Date: Wed, 8 Nov 2000 10:01:04 +0100 Subject: RE: create table SOLVED 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_01C04962.725E3C58 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all=20 It was a syntax problem :=20 It should be :=20 create table table2 tablespace tools as (select * from table1) ;=20 instead of=20 create table table2 as (select * from table1) tablespace tools;=20 =20 Thanks deepak=20 =20 -----Message d'origine-----=20 De: DEMANCHE Luc (Cetelem)=20 Date: mardi 7 novembre 2000 17:53=20 =C0: 'oracle-l@fatcity.com'=20 Objet: create table=20 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_01C04962.725E3C58 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: create table SOLVED

Hi all

It was a syntax problem :
It should be :
create table table2 = tablespace tools as (select * from table1) ;
instead of
create table = table2 as (select * from table1) tablespace tools;

 
Thanks deepak