Message-Id: <10720.125309@fatcity.com> From: Amar Kumar Padhi Date: Sun, 24 Dec 2000 14:59:07 +0400 Subject: RE: Tablespace 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 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@emirates.com amar_padhi@hotmail.com amar_padhi@musclemail.com amar_the_wizkid@yahoo.com AmZone.netfirms.com -----Original Message----- From: Kevin Kostyszyn [mailto:kevin@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" RE: How much beer should a DBA consume? (Lots)
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@emirates.com
amar_padhi@hotmail.com
amar_padhi@musclemail.com
amar_the_wizkid@yahoo.com
AmZone.netfirms.com

 
-----Original Message-----
From: Kevin Kostyszyn [mailto:kevin@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