You're missing something, but I couldn't say what...

I tried toying with the same thing, but I'm having a lazy afternoon, so I 
used Enterprise Manager:

Set up a new tablespace, created the table, sounds the same so far...

put a few rows into it, again using the nice graphical interface that 
avoids having to think or know what you're doing ;-)

Made the tablespace read only, checked that I couldn't update the table 
any more.

Dropped the table - gone, no complaints from the database.

The tablespace map shows the segment that had been being used by the table 
as a temporary segment.

Your suggestion about the metadata makes sense, the bitmap held in the LMT 
can't be the only information about that segment.
When I get my brain back in gear, I'll try and work out where else to look 
for a better idea of what's happening.

Cheers

Simon Anderson







Rachel Carmichael <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
18/06/2003 18:29
Please respond to ORACLE-L

 
        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc: 
        Subject:        Re: Partitions of table read only


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?


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).

Reply via email to