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).
Received on Wed Jun 18 2003 - 11:46:46 CDT
