dictionary to LMT

From: Doug Gernaat <dag_at_its.msstate.edu>
Date: Wed, 30 Aug 2006 09:36:49 -0500
Message-Id: <s4f55c4c.035@mailhost.groupwise.msstate.edu>

got a 9.2.0.7 db with dictionary managed tablespaces. after execution of >exec
dbms_space_admin.tablespace_migrate_to_local('EVIS'); extent management indeed becomes "local". with 40 tablespaces, i don't want to
tackle the task of breaking it down to 4 or 5 differently sized tablespaces with
uniform extents and figuring out which objects need to go to which tablespace.
but my question is... is there a way to change allocation_type from user to system?
i'm guessing this can only be done at creation time? here are the current values:

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT

MIN_EXTENTS
------------------------------ ---------- -------------- -----------

MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
----------- ------------ ---------- --------- --------- --------- ---

ALLOCATIO PLU SEGMEN DEF_TAB_
--------- --- ------ --------

EVIS                                 2048          51200       51200   
       1
         99            0          0 ONLINE    PERMANENT LOGGING   NO 
LOCAL
USER      NO  MANUAL DISABLED

OEM(version 9.2.0.1) shows that this tablespace is locally managed with automatic allocation and
manual segment space management. not sure why it has "automatic allocation" since
it just uses the storage values of the tablespace unless explicitly set during table creation.
OEM(10g grid) shows allocation type = uniform. what???

thanks
-doug-
--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 30 2006 - 09:36:49 CDT