Re: backing up partitioned table

From: Tony Johnson <tonyj_at_primenet.com>
Date: Mon, 22 Nov 1999 06:14:01 -0700
Message-ID: <38394198.106BE1F2@primenet.com>

can only make whole partition read-only. perhaps doing on a weekly basis would give more
but smaller partitions and allow you to set each weeks partitions to r/o.

Saugato Mukerji wrote:

> 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.
>
> thanks
>
> Saugato Mukerji

Tony Johnson
The Straford Group
PO Box 2875
Chandler, AZ 85225

Email : tonyj_at_primenet.com
Phone : (480)497-9685 Received on Mon Nov 22 1999 - 07:14:01 CST