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 <tablespace_name> 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> </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>    Does anybody here   know how to defrag a tablespace?  Because I do not even hava a   clue?  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> </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