Re: big table headache
Date: Sat, 13 Jan 2001 01:46:21 +1100
Message-ID: <3a5f18b0_at_news.iprimus.com.au>
Since DVD is, what?, 13Gb maximum, how many DVD's will she need to back up a 500Gb table?????!
I can just see her swapping 39 DVD disks every evening. Not.
Sounds like junior DBA work to me.
HJR
"N.N." <asko.makitalo_at_elomatic.com> wrote in message
news:Iff76.179$pd7.4018_at_read2.inet.fi...
> Hi!
>
> Some ideas...
>
> Divide the data somehow. Use different tablespaces for different year.
> Backup only modifyed tablespace.
> Sure you use 8.1.5> EE.
> Burn archives to DVD-RAM.
> Use DVD stock.
>
> Asko
> susana73_at_hotmail.com wrote in message <93jp96$g9g$1_at_nnrp1.deja.com>...
> >Hi all,
> >
> >I have a database consists of 30 tables around 500GB. 29 of them are a
> >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
> >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 Fri Jan 12 2001 - 15:46:21 CET