Tom Miskiewicz <miskiewicz2_at_no.spam.yahoo.com> wrote:
>> It's not really that difficult. You get the name of the segment from the
>> first query I gave you, and then you issue the command:
>>
>> drop table fredtbl cascade constraints;
>> drop index blah;
>> drop cluster foo;
>>
>> ...or whatever other segment types you have listed.
>
>BTW, I'm currently trying to drop the tablespace. It's 250MB big
>but the Enterprise Manager is thinking already since 2 hours...
>Can someone tell me, what the heck is going on with this box?
Check the number of extents, particularly if it's a Dictionary Managed
Tablespace. Last week I had to drop a user who'd managed to have close
to 50,000 extents, a single segment had over 20,000. It took Oracle
a few hours to do the processing for that. Converting that instance
(fortunately just a prototyping instance) to LMT with uniform extents
is on my to-do list :-).
--
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/
Received on Mon Oct 14 2002 - 05:56:48 CDT
