Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DROP LMT TBS internals.

RE: DROP LMT TBS internals.

From: Mohan, Ross <RMohan_at_arbinet.com>
Date: Mon, 20 Sep 2004 17:01:44 -0400
Message-ID: <CC74E7E10A8A054798B6611BD1FEF4D306330F07@vamail01.thexchange.com>


If you have an "over burdened" DD, (FET$, UET$, FILE$, TSQ$, etc.) drops even of LMTs things can be painful. SJHussain, I'd wager you're on an old version of the db, yes?

-----Original Message-----
From: Connor McDonald [mailto:hamcdc_at_yahoo.co.uk] Sent: Sunday, September 19, 2004 9:03 PM To: oracle-l_at_freelists.org
Subject: Re: DROP LMT TBS internals.

LMT's should drop extremely quickly...assuming its empty. If you've got objects in there, then the dictionary tables for the objects need to be updated.

Even if the tspace is empty, if you've got quotas assigned, then the TSQ$ dictionary table needs to be updated as the tablespace is dropped.

Cheers
Connor


Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"


                                  
___________________________________________________________ALL-NEW Yahoo!
Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 20 2004 - 15:57:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US