| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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_01C07727.E006B620
Content-Type: text/plain;
charset="iso-8859-1"
Because the to-be-created table is initially created as a numbered, "temporary" segment, and when work is complete, renamed by oracle to the final table/object name.
You can see this work in progress if, as the table builds, you select name, bytes, tablespace_name from user_segments where segment_type='TEMPORARY'.
hth
Ross Mohan
-----Original Message-----
From: Naik, Kevin K [mailto:KNaik_at_mail.sbic.co.za]
Sent: Friday, January 05, 2001 5:31 AM
To: Multiple recipients of list ORACLE-L
Subject: Sort Space
Hi All,
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
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relating to the official business of Standard Bank Investment Corporation (Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law. Stanbic does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic.
The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way.
Stanbic can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference.
------_=_NextPart_001_01C07727.E006B620
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.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=76195614-05012001><FONT face=Arial color=#0000ff size=2>Because
the to-be-created table is initially created as a </FONT></SPAN></DIV>
<DIV><SPAN class=76195614-05012001><FONT face=Arial color=#0000ff
size=2>numbered, "temporary" segment, and when work is complete,
</FONT></SPAN></DIV>
<DIV><SPAN class=76195614-05012001><FONT face=Arial color=#0000ff size=2>renamed
by oracle to the final table/object name. </FONT></SPAN></DIV>
<DIV><SPAN class=76195614-05012001><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=76195614-05012001><FONT face=Arial color=#0000ff size=2>You can
see this work in progress if, as the table builds, you</FONT></SPAN></DIV>
<DIV><SPAN class=76195614-05012001><FONT face=Arial color=#0000ff size=2>select
name, bytes, tablespace_name from user_segments</FONT></SPAN></DIV>
<DIV><SPAN class=76195614-05012001><FONT face=Arial color=#0000ff size=2>where
segment_type='TEMPORARY'.</FONT></SPAN></DIV>
<DIV><SPAN class=76195614-05012001><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=76195614-05012001><FONT face=Arial color=#0000ff
size=2>hth</FONT></SPAN></DIV>
<DIV><SPAN class=76195614-05012001><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=76195614-05012001><FONT face=Arial color=#0000ff size=2>Ross
Mohan</FONT></SPAN></DIV>
<DIV><SPAN class=76195614-05012001></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-----Original Message-----<BR><B>From:</B> Naik, Kevin K
[mailto:KNaik_at_mail.sbic.co.za]<BR><B>Sent:</B> Friday, January 05, 2001 5:31
AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Sort
Space<BR><BR></FONT></DIV>
<P><FONT size=2>Hi All,</FONT> </P>
<P><FONT size=2>Can anyone tell me, when I run a statement such as:</FONT>
</P>
<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> <DIV> <DIR><FONT color=#0000ff size=1> <P>______________________________________________</FONT><FONT face=Arialsize=1><B><FONT face=Arial size=2></FONT></B></FONT></P> <P><FONT face=Arial size=1><B><FONT face=Arial size=2>Disclaimer and confidentiality note</B></FONT></FONT></P> <P><FONT face=Arial size=1><FONT face=Arial size=2>Everything in this e-mail and any attachments relating to the official business of Standard Bank Investment Corporation</FONT><FONT face=Arial color=#0000ff size=2> </FONT><FONT face=Arial size=2>(Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law. Stanbic</FONT><FONT face=Arial color=#0000ff size=2> </FONT><FONT face=Arial size=2>does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic. </FONT></FONT></P> <P><FONT face=Arial size=1><FONT face=Arial size=2>The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way.</P>
size=1> _______________________________________________</FONT></P></FONT></DIV></BLOCKQUOTE></BODY></HTML>Received on Fri Jan 05 2001 - 08:57:51 CST
 |
 |