By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

Oracle Truncate problems

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ritu wrote:
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


As an alternative, you may wish to look at Partitioning.
Jul 19 '05 #2

P: n/a

"Ritu" <rc****@rediffmail.com> wrote in message
news:87**************************@posting.google.c om...
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
Jul 19 '05 #3

P: n/a
Ritu wrote:
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
As an alternative, you may wish to look at Partitioning.
Jun 27 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.