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: Slick tricks for extent size reduction in LMTS via LMTS=>DM=> LMTS ?

RE: Slick tricks for extent size reduction in LMTS via LMTS=>DM=> LMTS ?

From: Feighery Raymond <Raymond.Feighery_at_churchill.com>
Date: Thu, 22 Jul 2004 10:47:37 +0100
Message-ID: <817D2444710B934B9F7B8A1DAAF432D601F2AF5D@brcexm03>


Yes. I made this exact point in my earlier post.

Ray

-----Original Message-----

From: Powell, Mark D [mailto:mark.powell_at_eds.com] Sent: 21 July 2004 17:42
To: 'oracle-l_at_freelists.org'
Subject: RE: Slick tricks for extent size reduction in LMTS via LMTS=>DM=> LMTS ? But is the resulting tablespace defined as locally managed with uniform extents? The allocation_type column of dba_tablespaces appears to be either USER which means dictionary managed or null where normally it should show UNIFORM for a locally managed tablespace with uniform extents.

I do not have a test db available to use for testing right now but any process that results in my dictionary views not returning normal information makes me concerned that the process is not doing something correctly or that I misunderstood what I was looking at.


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Thu Jul 22 2004 - 04:44:12 CDT

Original text of this message

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