Re: create table

From: Tom Pall <tom_at_cdproc.com>
Date: Tue, 7 Nov 2000 13:14:55 -0600
Message-Id: <10673.121344@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_12EE_01C048BC.B8B009D0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

create table

Create table table2 tablespace tools (storage parameters ...) as = (select * from table1;

Original Message -----=20 From: DEMANCHE Luc (Cetelem)=20 To: Multiple recipients of list ORACLE-L=20 Sent: Tuesday, November 07, 2000 11:40 AM 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 =

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_000_12EE_01C048BC.B8B009D0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>create table</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Create table table2 tablespace  tools (storage =
parameters=20
...) as (select * from table1;</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:luc.demanche_at_cetelem.fr"=20   title=3Dluc.demanche_at_cetelem.fr>DEMANCHE Luc (Cetelem)</A> </DIV>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, November 07, = 2000 11:40=20
  AM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> create table</DIV>
  <DIV><BR></DIV>
  <P><FONT face=3DArial size=3D2>Hi gurus,</FONT> </P>
  <P><FONT face=3DArial size=3D2>I have no problem with this :&nbsp;=20
  </FONT><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =

face=3DArial=20
size=3D2>create table table1 (a number) tablespace tools</FONT> </P> <P><FONT face=3DArial size=3D2>But I can't do this :</FONT>=20 <BR>        <FONT face=3DArial = size=3D2>create=20
table table2 as (select * from table1) tablespace tools</FONT> </P>

  <P><FONT face=3DArial size=3D2>What is the solution</FONT> </P>
  <P><FONT face=3DArial size=3D2>TIA</FONT> </P>
  <P><FONT face=3DArial size=3D2>-----------------</FONT> <BR><FONT =

face=3DArial=20
  size=3D2>Luc Demanche</FONT> <BR><B><I><FONT = face=3DArial>CETELEM</FONT></I></B>=20
  <BR><FONT face=3DArial size=3D2>T=E9l.: 01-46-39-14-49</FONT> =
<BR><FONT face=3DArial=20

  size=3D2>Fax : 01-46-39-59-88</FONT> </P></BLOCKQUOTE></BODY></HTML> Received on Tue Nov 07 2000 - 13:14:55 CST