Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tablespace

RE: Tablespace

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Sun, 24 Dec 2000 14:59:07 +0400
Message-Id: <10720.125309@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_01C06D98.892FED50
Content-Type: text/plain;

        charset="iso-8859-1"

alter tablespace <tablespace_name> coalesce

for each datafile in the tablespace, coalesce all contiguous free extents into larger contiguous extents. Check this out...

Thanks,
Amar kumar Padhi
00-971-50-7883254
ts2017_at_emirates.com

amar_padhi_at_hotmail.com 
amar_padhi_at_musclemail.com 
amar_the_wizkid_at_yahoo.com 

AmZone.netfirms.com  

-----Original Message-----
From: Kevin Kostyszyn [mailto:kevin_at_dulcian.com] Sent: Saturday, December 23, 2000 12:52 AM To: Multiple recipients of list ORACLE-L Subject: Tablespace

Hi all,

    Does anybody here know how to defrag a tablespace? Because I do not even hava a clue? Thanks in advance.
Oracle 8.1.6 DB  

Kevin Kostyszyn
Dulcian, Inc

------_=_NextPart_001_01C06D98.892FED50
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>RE: How much beer should a DBA consume? (Lots)</TITLE>

<META content="MSHTML 5.00.3019.2500" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face="Courier New" size=2><SPAN
class=418165210-24122000>alter tablespace &lt;tablespace_name&gt; coalesce</SPAN></FONT></DIV>
<DIV>
<P class=TB><FONT size=2><FONT color=#0000ff><FONT face="Courier New">for each
datafile in the tablespace, coalesce all contiguous free extents into larger contiguo<SPAN class=418165210-24122000>u</SPAN>s extents<SPAN class=418165210-24122000>. Check this
out...</SPAN></FONT></FONT></FONT></P></DIV>
<P><FONT color=#000000 face="Courier New" size=2>Thanks,</FONT> <BR><B><FONT
color=#808080 face="Courier New" size=2>Amar kumar Padhi<I></I></FONT></B>
<BR><FONT color=#808080 face="Courier New" size=2>00-971-50-7883254</FONT>
<BR><FONT color=#808080 face="Courier New" size=2>ts2017_at_emirates.com</FONT>
<BR><FONT color=#808080 face="Courier New" size=2>amar_padhi@</FONT><B><FONT
color=#808080 face="Courier New" size=2>hot</FONT></B><FONT color=#808080

face="Courier New" size=2>mail.com</FONT> <BR><FONT color=#808080 
face="Courier New" size=2>amar_padhi@</FONT><B><FONT color=#808080 
face="Courier New" size=2>muscle</FONT></B><FONT color=#808080 
face="Courier New" size=2>mail.com</FONT> <BR><FONT color=#808080 
face="Courier New" size=2>amar_the_wiz</FONT><B><FONT color=#808080 
face="Courier New" size=2>kid</FONT></B><FONT color=#808080 face="Courier New" 
size=2>@yahoo.com</FONT> <BR><U><FONT color=#808080 face="Courier New" 
size=2>AmZone.netfirms.com</FONT></U> </P>

<DIV>&nbsp;</DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

  <DIV class=OutlookMessageHeader><FONT face="Times New Roman"   size=2>-----Original Message-----<BR><B>From:</B> Kevin Kostyszyn   [mailto:kevin_at_dulcian.com]<BR><B>Sent:</B> Saturday, December 23, 2000 12:52   AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>   Tablespace<BR><BR></DIV></FONT>
  <DIV><SPAN class=812403520-22122000><FONT color=#0000ff face=Arial   size=2><SPAN class=812403520-22122000>Hi all,</SPAN></FONT></SPAN></DIV>   <DIV><SPAN class=812403520-22122000><FONT color=#0000ff face=Arial   size=2><SPAN class=812403520-22122000>&nbsp;&nbsp;&nbsp; Does anybody here   know how to defrag a tablespace?&nbsp; Because I do not even hava a   clue?&nbsp; Thanks in advance.</SPAN></FONT></SPAN></DIV>   <DIV><SPAN class=812403520-22122000><FONT color=#0000ff face=Arial   size=2><SPAN class=812403520-22122000>Oracle 8.1.6   DB</SPAN></FONT></SPAN></DIV>
  <DIV><SPAN class=812403520-22122000><FONT color=#0000ff face=Arial   size=2><SPAN class=812403520-22122000></SPAN></FONT></SPAN>&nbsp;</DIV>   <DIV><SPAN class=812403520-22122000><FONT color=#0000ff face=Arial   size=2><SPAN class=812403520-22122000>Kevin   Kostyszyn</SPAN></FONT></SPAN></DIV>
  <DIV><SPAN class=812403520-22122000><FONT color=#0000ff face=Arial   size=2><SPAN class=812403520-22122000>Dulcian, Inc</SPAN></FONT></SPAN></DIV></BLOCKQUOTE></BODY></HTML> Received on Sun Dec 24 2000 - 04:59:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US