RE: create table

From: Wolfe, Charles <charles.wolfe_at_digex.com>
Date: Tue, 7 Nov 2000 13:40:50 -0500
Message-Id: <10673.121337@fatcity.com>

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

-----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
Fax : 01-46-39-59-88=20 Received on Tue Nov 07 2000 - 12:40:50 CST