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).
