From wisernet100@yahoo.com Wed, 18 Jun 2003 09:16:54 -0700 From: Rachel Carmichael Date: Wed, 18 Jun 2003 09:16:54 -0700 Subject: Re: Partitions of table read only Message-ID: MIME-Version: 1.0 Content-Type: text/plain that actually makes sense when you think about it, with one question -- was the tablespace a dictionary-managed one or an LMT? If it was dictionary-managed, it makes perfect sense. The metadata about the table and the extents used in the tablespace are not stored IN that tablespace, so drop table would affect only the system tablespace and the data dictionary. But in an LMT, the bitmap of extent usage is stored within the tablespace itself, so I wonder if you could actually drop a table from a read-only lmt. Off to experiment...... Rachel --- Darrell Landrum <[EMAIL PROTECTED]> wrote: > 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] > Visit our web site at 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). __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).