Re: VLDB topic

Partitioned tables is the best answer.
You have to convert your tables to partitioned tables.

Or if

• you don't need to access old data
• the DB is 'idle' after midnight you can export them regularly using scheduler to run job at night and delete the records from original tables. If you do it every midnight the increment will be small enough.

In article <974753765.21384.1.nnrp-02.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 21 2000 - 02:32:05 CST