RE: Delete vs. truncate to free up spaces.

From: Nguyen, David M <david.m.nguyen_at_xo.com>
Date: Mon, 22 Dec 2003 15:29:26 -0800
Message-ID: <F001.005DAA97.20031222152926@fatcity.com>

It's Oracle8i Enterprise Edition.

-----Original Message-----
Jacques Kilchoer
Sent: Monday, December 22, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L

This is one of the cases where a partitioned table can be of great use. What version of Oracle? Standard or Enterprise Edition? With a partitioned table you can say
alter table ... drop partition ... ;
to easily get rid of a large chunk of data and release the space.

See
Oracle9i Database Concepts Release 2 (9.2) Part Number A96524-01
Chapter 11
Partitioned Tables and Indexes
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c12p arti.htm#464767

or

http://tinyurl.com/362ba

-----Original Message-----
Nguyen, David M

I am using delete command to delete million records in several tables to free up space in tablespace. I understand delete command does not release unused spaces as truncate command but I could not use truncate to delete ALL records in table as I need to keep one month old of records in table. Please advise a better method I can use to free up spaces.
Thanks,
David
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Nguyen, David M
  INET: david.m.nguyen_at_xo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Dec 22 2003 - 17:29:26 CST