Re: VLDB topic

The 'modern' way to do this is through the use of Partitioned Tables. (See my web-site, and the book when its available).

In this case, the strategy would be to use range-partitioning, with a date (age) based range. In this way, the requirement to

    'delete all data prior to 1st jan 2000' could become

    alter table big_table drop partition p2000_01;

Total elapsed time typically a few seconds, with virtually no rollback and redo.. You also get the benefit that older partitions (data) can be segregated into separate tablespaces, which can be made read-only - which reduces the need for regular large backups.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison Wesley Longman
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
Order from Amazon via: http://www.jlcomp.demon.co.uk

ibm_97_at_yahoo.com wrote in message <8vbvho$sco$1_at_nnrp1.deja.com>...


>Hi,

>

>For a Oracle 8i VLDB on Solaris which is growing constantly, we try to

>make a plan to do the 'archive' job. This means we have to backup some

>old data and delete them from database to free more space for new data.

>The 'delete' in Oracle is very expensive, and I want to know:

>

>for this kind of VLDB in your guys' sites, what's your plan to

>do 'arcvhive' job? Setup more boxes, or something else? Also, is there

>any 3rd party tool to do this kind of job? How about the performance?

>('cause while you delete old data, the new data are being inserted all

>the time).

>

>Thanks for any suggestions!!

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.