Re: backing up partitioned table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 22 Nov 1999 19:36:15 -0000
Message-ID: <943300699.8301.0.nnrp-03.9e984b29@news.demon.co.uk>

You will need a strategy of storing different partitions in different tablespaces (perhaps one tablespace per week/month), and then making the tablespaces read only.

Since you are at 8.1.5 it would be sensible to make these tablespaces locally managed rather than dictionary managed, as you can then name them with an ascending calendar- related name without growing the TS$
cluster unnecessarily.

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

Saugato Mukerji wrote in message <81avsn$95f28_at_atbhp.corpmel.bhp.com.au>...
>hi
>
>
>i have a table called HISTORY_DATA that will grow 60MB/day . I would like
to
>partition the table adding partitions every month.
>
>The data is entirly historical and unlikely to be altered after 1 week.
>
>Can i make the older partitions of HISTORY_DATA read only
>
>Can i backup only the non read only partitions during closed and online
>backups.
>
>The platform is 8.1.5 on NT 4.0.
Received on Mon Nov 22 1999 - 13:36:15 CST