Re: Oracle Truncate problems

"Ritu" <rc0972_at_rediffmail.com> wrote in message news:8777cccd.0404071250.7b63bc62_at_posting.google.com...
> Hello Folks,
>
> I chanced upon this newsgroup in my search for a solution to a problem
> I am facing. I hope someone can give me a pointer.
>
> I have a table in an Oracle 8i database that performs the function of
> a log. It has a hit of approximately 2 records a second. Such a large
> volume of data eats into our tablespace and we have decided to
> summarize the data in this table. So we have a function that
> summarizes the data, inserts it into a new summary table and then
> frees space on this table.
>
> The problem we face are as follows
>
> 1. Mere deletion of records we have discovered does not free the table
> space. This only happens on Truncate. In order to use the Truncate
> command we have to drop the entire table rather than delete a select
> set of records as we need.
>
> 2. While we are truncating the table, what happens to the attempts to
> access this table?
>
> Is there some way to selectively compress or free table space without
> stopping our operation?
>
> I would be very glad if someone takes a few minutes off and helps us
> out.
>
> Regards,
> Ritu

You can delete the records and then alter the table unused the storage (look in docs for the alter table command)
Then any space at the end of the table will be released. Or as another poster said, use partitioning
Jim Received on Thu Apr 08 2004 - 04:00:04 CEST