Re: DROP LMT TBS internals.

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Mon, 20 Sep 2004 02:03:20 +0100 (BST)
Message-ID: <20040920010320.64966.qmail@web86906.mail.ukl.yahoo.com>

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

• SJHussain_at_alfransi.com.sa wrote:
  >
  >
  >
  >
  > Hello List,
  >
  > If I am dropping a LMT Tablespace and it takes a long time, how can I know
  > that the process is running, not hanged. Can anyone let me know what are
  > the internal functionality of drop tablespace. I know that we can check
  > fet$ for DMT TBS, how about LMT TBS?
  >
  >
  

  ---

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

Received on Sun Sep 19 2004 - 19:58:52 CDT