RE: Slick tricks for extent size reduction in LMTS via LMTS=>DM=> LMTS ?
- From: "Mohan, Ross" <RMohan@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Jul 2004 11:41:47 -0400
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 //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
-----------------------------------------------------------------
Other related posts:
