RE: create table

From: Suri, Deepak <DSuri_at_oxhp.com>
Date: Tue, 7 Nov 2000 13:37:44 -0500
Message-Id: <10673.121336@fatcity.com>

Try changing the positions according to the statement syntax. Type :
=20

create table table2 tablespace tools as (select * from table1) ;
=20

worked for me !
=20

deppak

-----Original Message-----
From: DEMANCHE Luc (Cetelem) [mailto:luc.demanche_at_cetelem.fr] Sent: Tuesday, November 07, 2000 12:41 PM To: Multiple recipients of list ORACLE-L 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=20

What is the solution=20

TIA=20

-----------------=20

Luc Demanche=20
CETELEM=20
T=E9l.: 01-46-39-14-49=20 Received on Tue Nov 07 2000 - 12:37:44 CST