okay, am I missing something? I created an LMT. Created a table in it. Gave no one quota on the tablespace.
did (both as system and sysdba) alter tablespace test_drop read only; and hung what did I forget to do? --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > 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] <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). > > > __________________________________ > 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). __________________________________ 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).