Rachel, You forgot to kill all other active transactions... ;(
- Kirti --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > 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] > > > > > __________________________________ 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: Kirtikumar Deshpande 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).
