create table

From: DEMANCHE Luc (Cetelem) <luc.demanche_at_cetelem.fr>
Date: Tue, 7 Nov 2000 17:52:47 +0100
Message-Id: <10673.121323@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>

<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>create table</TITLE>
</HEAD>
<BODY>

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
Received on Tue Nov 07 2000 - 10:52:47 CST