Ray, Tried. Repeatedly. Gave me ora- error each time I tried to shrink below the previous uniform size. "Invalid Size". No joy. -----Original Message----- From: Feighery Raymond [mailto:Raymond.Feighery@xxxxxxxxxxxxx] Sent: Wednesday, July 21, 2004 10:02 AM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: Slick tricks for extent size reduction in LMTS via LMTS=>DM=> LMTS ? Ross You can do it in the way your subject line suggests using: 1) dbms_space_admin.tablespace_migrate_from_local 2) alter tablespace (change default storage extent size and minimum extent) 3) dbms_space_admin.tablespace_migrate_to_local However, already existing tables will retain their existing storage parameters (unless you change them at step 2) and you will have to have a dictionary managed SYSTEM tablespace to change the LMT to dictionary-managed at step 1. dbms_space_admin.tablespace_migrate_to_local has some side effects. Although you will get the performance benefits of an LMT you will no longer get the policy enforcement of extent sizes (i.e. the ALLOCATION_TYPE column in dba_tablespaces will show as USER not UNIFORM or SYSTEM). Another is that the next extent storage attribute does not get reset on deallocation of extents (this only matters if PCTINCREASE > 0). Ray -----Original Message----- From: Mohan, Ross [mailto:RMohan@xxxxxxxxxxx] Sent: Wednesday, July 21, 2004 12:21 AM 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 http://www.freelists.org/archives/oracle-l/ FAQ is at http://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 http://www.freelists.org/archives/oracle-l/ FAQ is at http://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 http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------