Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sort Space
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
++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++
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></SPAN> </DIV>
<DIV><SPAN class=860215214-05012001>Is this what you are seeing?</SPAN></DIV>
<DIV><SPAN class=860215214-05012001></SPAN> </DIV>
<DIV><SPAN class=860215214-05012001>Regards</SPAN></DIV>
<P><FONT size=2>Kevin N</FONT> </P></BLOCKQUOTE><FONT SIZE=3D3 COLOR=3DBLUE><PRE>++++++++++++++++++++++++++++++++++++All internet traffic to this site is
++++++++++++++++++++++++++++++++++++</PRE></FONT>Received on Fri Jan 05 2001 - 09:02:39 CST