Re: Locally vs Dictionary-Managed Tablespaces - was archive query -

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Thu, 06 Sep 2001 05:55:24 -0700
Message-ID: <F001.00384FA6.20010906050523@fatcity.com>

True - but it only really "works" if you've already been using good choices for extent sizes. To build the bitmap it needs to come up with the greatest common divisor for every extent size in the tablespace. If you had two extents which were (say) 96k and 104k, then your bitmap will have an entry for each 8k block in the file... not so great.

hth
connor

• Joe Testa <teci_at_the-testas.net> wrote: > I'm evidently missing something here. This is the
  > 2nd time i've heard
  > that you can't convert a tablespace between local
  > and dictionary
  > managed.
  > DBMS_SPACE_ADMIN package lets you convert from one
  > format to another w/o
  > rebuilding it, look at tablespace_migrate_(from ||
  > to) local procedures.
  >
  > I dont think a rebuild is necessary, i've not used
  > them yet(soon
  > though).
  >
  > 8.1.7 docs.
  >
  > joe
  >
  > --
  > Joe Testa
  > Performing Remote DBA Services, need some backup DBA
  > support?
  > For Sale: Oracle-dba.com domain, its not going cheap
  > but feel free to
  > ask :)
  > IM: n8xcthome or joen8xct
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Joe Testa
  > INET: teci_at_the-testas.net
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (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).
  

  ---

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

---

Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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 Thu Sep 06 2001 - 07:55:24 CDT