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).
Received on Wed Jun 18 2003 - 12:26:42 CDT
