Re: How to defragment a big table not using import?

Susan,

Two things. First, how are you backing this up?! It sounds suspiciously like you're not. Remember, a DBA is only as good as their last backup. :-) Seriously, I'd solve this problem first, which will also give you the means to handle the reorg. Second, if a lot of the space is unused and you use some sort of compression, you won't need 100GB. How much you actually do need will depend on the percentage of unused space and the compressibility of your data. BLOBs, unfortunately, don't tend to compress that well.

If you have sufficient free disk space, you can create a copy of the table with different storage parameters and then drop the original and rename the copy.

Question: Are the insert/delete operations for the whole range of data are are they focused on a particular time frame? If transactions are only occurring on recent data, you might want to investigate partitioning (assuming you're using 8.xx). This would limit the amount of reorging necessary in the future.

Good luck.

Byron Lee

<susana73_at_hotmail.com> wrote in message news:8gf57g$8pa$1_at_nnrp1.deja.com...
> Hi,
>
> I have a 200GB database. One of the tables contained blob has occupied
> 100GB alone. This table is consistently insert/delete everyday. I
> looked into the space within the table. It looks like there is a lot of
> empty blocks(inside the table) which is wasting a lot of space. I like
> to deframent it so that I can have a smaller table(segment) size. But I
> don't have a 100GB disk/tape for export/import. What should I do?
>
> Thanks!!
>
> Susan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue May 23 2000 - 00:00:00 CDT