RE: DELETE ROWS - how to recover disk space
Posted in 1999
Topics: Storage & Space Management, Migration, Import/Export & Data Conversion
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_01BF30FE.D7DAE89C
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
You can perform an dbexport, check that it=B4s OK, after drop the =
database and
finally run dbimport.
Manolo
:)
-----Original Message-----
From: Valerie [mailto:vgerauxNOvgSPAM@caramail.com.invalid]
Sent: Mi=E9rcoles, 17 de Noviembre de 1999 04:22 a.m.
To: informix-list@iiug.org
Subject: DELETE ROWS - how to recover disk space
Hi!
When I perform this :
DELETE FROM <table> WHERE <condition>;
Rows are deleted, but I cannot recover the disk space. I
know that free rows are used later by new records, but
today my disk is more than 95% full and processing time is
excessive.
Please help me to recover disk space.
Any idea will be greatly appreciated.
Valerie.
* Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart =
is
Beautiful
------_=_NextPart_001_01BF30FE.D7DAE89C
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2232.0">
<TITLE>RE: DELETE ROWS - how to recover disk space</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>You can perform an dbexport, check that it=B4s OK, =
after drop the database and finally run dbimport.</FONT>
</P>
<P><FONT SIZE=3D2>Manolo</FONT>
<BR><FONT SIZE=3D2>:)</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Valerie [<A =
HREF=3D"mailto:vgerauxNOvgSPAM@caramail.com.invalid">mailto:vgerauxNOvgS=
PAM@caramail.com.invalid</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Mi=E9rcoles, 17 de Noviembre de 1999 04:22 =
a.m.</FONT>
<BR><FONT SIZE=3D2>To: informix-list@iiug.org</FONT>
<BR><FONT SIZE=3D2>Subject: DELETE ROWS - how to recover disk =
space</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi!</FONT>
</P>
<P><FONT SIZE=3D2>When I perform this :</FONT>
<BR><FONT SIZE=3D2>DELETE FROM <table> WHERE =
<condition>;</FONT>
</P>
<P><FONT SIZE=3D2>Rows are deleted, but I cannot recover the disk =
space. I</FONT>
<BR><FONT SIZE=3D2>know that free rows are used later by new records, =
but</FONT>
<BR><FONT SIZE=3D2>today my disk is more than 95% full and processing =
time is</FONT>
<BR><FONT SIZE=3D2>excessive.</FONT>
</P>
<P><FONT SIZE=3D2>Please help me to recover disk space.</FONT>
<BR><FONT SIZE=3D2>Any idea will be greatly appreciated.</FONT>
</P>
<P><FONT SIZE=3D2>Valerie.</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>* Sent from AltaVista <A =
HREF=3D"http://www.altavista.com" =
TARGET=3D"_blank">http://www.altavista.com</A> Where you can also find =
related Web Pages, Images, Audios, Videos, News, and Shopping. =
Smart is Beautiful</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01BF30FE.D7DAE89C--
Related threads
- Conversion to differeent characters sets
- Control of CLIENT_LOCALE and DB_LOCALE at connection (doc issue?)
- Problem in changing locale via dbexport/dbimport
- Re: Matches not Work in 7.30
- DATABASE vs CONNECT TO: Invalid characters error?