Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Backup for Large Databases (800,000,000 rows) in one table
On 21 May 2001 10:50:13 -0700, samara.marwan_at_epa.gov (Marwan Samara) wrote:
>The largest table is partitioned by year, and contains
>about 800,000,000 rows with average length of 100 bytes.
So, would that be around 80Gb?
>Now, a hot backup is taking about 7 hours, and never tried the restore.
You need a faster backup device to start with.
Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html
Received on Tue May 22 2001 - 05:36:02 CDT