Re: Partitions of table read only

I haven't tested this but would imagine it entirely possible. What I wanted to throw out though, is somewhat of a related caution. You can drop a table from a read only tablespace. I discovered this in test, fortunately when I was finished testing with that table and intentionally dropped it while the tablespace was in read only mode.

>>> [EMAIL PROTECTED] 06/18/03 09: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: Darrell Landrum
  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).