Re: Partitions of table read only

Jack,
 We use the methods you are asking about. The partitions are created and the table uses the range option to place the data in the correct partition according to the date field. Each year I place the partition in a read-only status and the back it up and place it on the shelf. RMAN will not backup the read-only data normally so the backup time decreases. It makes the data managable and I can move the read-only partitions to an "archive" disk to reduce the i/o on the "active" disks.
Ron

>>> [EMAIL PROTECTED] 06/18/03 10:49AM >>>
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] <mailto:[EMAIL PROTECTED]> Visit our web site at http://www.quantsystems.nl/ <http://www.quantsystems.nl/>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).