Mark, Thanks. ....well...a drop/resurrect.....to change the extent size to something I want, yes. (i.e. something smaller) Apparently if the new/requested extent size is "a factor" of the minimum already-used extent size in the tspace, I can change it but that implies only upward extent size growth. not what I had in mind. Also, the FMs are a tad opaque on this issue. They refer to something called an "allocation_unit" (which I think may really be blocks, but the only specific I was able to dig up in one place said it was in bytes. Go figure.) and the process for figuring out the allowable extent size modifications rivals Andrew Wile's proof of Fermat's Last Theorem, involving Greatest Common Divisors of Multiple Factors in Minimum Spanning Spaces over a Field of Binary Integers Maximized in a Bitmap. Kind of like a title to an early, early Pink Floyd song. ( Two somethings Groovin' in a Cave with a Pict or somesuch) Anyway, back to Oracle. (God, this is exciting.) -----Original Message----- From: Powell, Mark D [mailto:mark.powell@xxxxxxx] Sent: Wednesday, July 21, 2004 8:16 AM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: Slick tricks for extent size reduction in LMTS via LMTS=>DM=> LMTS ? No, you are not wrong. You need to drop and recreate a tablespace to change the uniform extent size. HTH -- Mark D Powell -- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mohan, Ross Sent: Tuesday, July 20, 2004 7:21 PM To: oracle-l@xxxxxxxxxxxxx Subject: Slick tricks for extent size reduction in LMTS via LMTS=>DM=>LMTS ? I am gathering, painfully, that once you create and partially populate a half terabyte tspace with local ext mgmt extent size 100M there's no way to reduce the extent size to, say, 5M. Please someone tell me I am wrong. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------