RE: Sort Space

From: Gillies, Garry <garry_at_weir.co.uk>
Date: Fri, 5 Jan 2001 15:02:39 -0000
Message-Id: <10732.125833@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_01C07728.8C15A5C0
Content-Type: text/plain;

charset="iso-8859-1"

Hi Kevin,
The statement

create table dummy2 as select * from dummy1

would not require any sorting, so no temporary segments would be created for this purpose.
Table dummy2 would initially be created as a temporary segment then changed to type table
after the data has been copied from dummy1. Since the segment is ultimately going to be
permanent, the temporary tablespace specification does not apply. Is this what you are seeing?

Regards

Garry

-----Original Message-----
Can anyone tell me, when I run a statement such as:

create table dummy2
as select * from dummy1

lets say the table has -+500 thousand records, why does this statement use the default tablespace for temporary work and NOT the temporary tablespace

defined for the user ?

Kevin N

++++++++++++++++++++++++++++++++++++

All internet traffic to this site is
automatically scanned for viruses
and vandals.

++++++++++++++++++++++++++++++++++++

------_=_NextPart_001_01C07728.8C15A5C0
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Sort Space</TITLE>

<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=860215214-05012001>Hi Kevin,</SPAN></DIV>
<DIV><SPAN class=860215214-05012001>The statement</SPAN></DIV>
<DIV><FONT color=#ff0000><SPAN

class=860215214-05012001></SPAN></FONT> </DIV>
<DIV><FONT color=#ff0000 size=4><SPAN class=860215214-05012001>create table
dummy2 as select * from dummy1 </SPAN></FONT></DIV>
<DIV><FONT color=#ff0000><SPAN

class=860215214-05012001></SPAN></FONT> </DIV>
<DIV><FONT color=#ff0000 size=2><SPAN class=860215214-05012001><FONT
color=#000000 size=3>would not require any sorting, so no temporary segments would be created for this purpose.</FONT></SPAN></FONT></DIV>
<DIV><SPAN class=860215214-05012001>Table dummy2 would initially be created as a
temporary segment then changed to type table</SPAN></DIV>
<DIV><SPAN class=860215214-05012001>after the data has been copied from dummy1.
Since the segment is ultimately going to be</SPAN></DIV>
<DIV><SPAN class=860215214-05012001>permanent, the temporary tablespace

specification does not apply.</SPAN></DIV>


<DIV><SPAN class=860215214-05012001>Is this what you are seeing?</SPAN></DIV>

<DIV><SPAN class=860215214-05012001></SPAN>&nbsp;</DIV>

<DIV><SPAN class=860215214-05012001>Regards</SPAN></DIV>

<DIV><SPAN class=860215214-05012001></SPAN> </DIV>
<DIV><SPAN class=860215214-05012001>Garry</SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

  <DIV class=OutlookMessageHeader><FONT size=2>-----Original   Message-----<BR></FONT><FONT size=2>Can anyone tell me, when I run a statement   such as:</FONT> </DIV>
  <P><FONT size=2>create table dummy2</FONT> <BR><FONT size=2>as select * from   dummy1</FONT> </P>
  <P><FONT size=2>lets say the table has -+500 thousand records, why does this   statement use the default tablespace for temporary work and NOT the temporary   tablespace</FONT></P>
  <P><FONT size=2>defined for the user ?</FONT> </P>

  <P><FONT size=2>Kevin N</FONT> </P></BLOCKQUOTE><FONT SIZE=3D3 COLOR=3DBLUE><PRE>++++++++++++++++++++++++++++++++++++

All internet traffic to this site is
automatically scanned for viruses
and vandals.

++++++++++++++++++++++++++++++++++++</PRE></FONT>

Received on Fri Jan 05 2001 - 09:02:39 CST