RE: Delete vs. truncate to free up spaces.

EE has enterprise on the CD, but it's an extra cost option. Make sure the license fees have been paid first, otherwise it could be a messy thing to rip out. BTDT.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Monday, December 22, 2003 7:14 PM
To: Multiple recipients of list ORACLE-L

Then you should have the partitioning option. Partition your table if you can.

> -----Original Message-----
> Nguyen, David M
>
> It's Oracle8i Enterprise Edition.
>
>
> -----Original Message-----
> Jacques Kilchoer
>
> 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/a
> 96524/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.

-- 
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: Goulet, Dick
  INET: DGoulet_at_vicr.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).