big table headache

[Quoted] Hi all,

[Quoted] I have a database consists of 30 tables around 500GB. 29 of them are a [Quoted] total of only 20 GB. There is a single table 'arch_struct' occupying almost 500GB alone. This is a table with blob and store the old record [Quoted] from the table 'struct'. Records got archived from 'struct' to 'arch_struct' every week. 'arch_struct' does get access(both read and write) but infrequently.

This gives me a lot of trouble in terms of backup and maintanence. It takes me a long time to backup, especially when I think about I only have 20GB regular data. I also found that Oracle does not reuse the deleted space efficently. I want to defragment it but I don't have 500GB space to dump it.

Any suggestion is appreciated.

Susan

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 11 2001 - 09:01:43 CET