RE: create table SOLVED

From: DEMANCHE Luc (Cetelem) <luc.demanche_at_cetelem.fr>
Date: Wed, 8 Nov 2000 10:01:04 +0100
Message-Id: <10674.121407@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_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_at_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

<!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>RE: create table SOLVED</TITLE>
</HEAD>
<BODY>

Hi all


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

SIZE=3D2 FACE=3D"Courier New">as (select * from table1)</FONT><I> <FONT =
SIZE=3D2 FACE=3D"Courier New">tablespace tools</FONT></I><FONT SIZE=3D2 =
FACE=3D"Courier New">;</FONT>

 
 Thanks deepak
  

<UL>
-----Message d'origine-----
 De:     DEMANCHE Luc (Cetelem) 
 Date:   mardi 7 novembre 2000 17:53
 =C0:      'oracle-l_at_fatcity.com'
 Objet:  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
Received on Wed Nov 08 2000 - 03:01:04 CST