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

Home -> Community -> Usenet -> c.d.o.server -> how to free idle space

how to free idle space

From: Umar FArooq <umar.farooq_at_cressoft.com.pk>
Date: Sat, 06 Jun 1998 18:18:05 +0500
Message-ID: <3579418D.49E321D5@cressoft.com.pk>


hi!
i would like to free some space from my Oracle database without loosing any data (so I cannot use the truncate command). Can anyone tell me what steps should I follow? Do i use the DEALLOCATE clause of the ALTER TABLE command? How does it function? What other ways r there which would enable me to free extraneous space.

Thx.

Umar
umar.farooq_at_cressoft.com.pk Received on Sat Jun 06 1998 - 08:18:05 CDT

Original text of this message

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