Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> backing up partitioned table

backing up partitioned table

From: Saugato Mukerji <Mukerji.Saugato.S_at_bhp.com.au>
Date: Mon, 22 Nov 1999 19:46:14 +1100
Message-ID: <81avsn$95f28@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.





thanks



Saugato Mukerji


Received on Mon Nov 22 1999 - 02:46:14 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US