Partitions of table read only

Hi,

I would like to know if it is possible and what the pitfalls are if  I do the following.

Partition a large table into partitions based on date. Data is only entered and read and never altered, so I would like to move older partitions to read only tablespaces and possible read only devices so the backup will be made quicker.

Is it possible to have parttions of the same table spread across read only and read/write tablespaces? Am I correct in assuming that once you backup a read only tablespace there is no need to backup the same again. (provided you don't make it read/write add data and make it read only again).?

Does anybody have a procedure already that automatically creates the new partitions let say every month?

TIA Jacob A. van Zanen
Oracle DBA
Quant Systems Europe b.v.
Tel : +31 (0) 251 - 268 268 
Mobile: +31 (0) 6 51308813
Fax: +31 (0) 251 - 268 269 
E-mail: [EMAIL PROTECTED]
Visit our web site at http://www.quantsystems.nl/ Received on Wed Jun 18 2003 - 09:11:33 CDT