dictionary to LMT
- From: "Doug Gernaat" <dag@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Aug 2006 09:36:49 -0500
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-
--
//www.freelists.org/webpage/oracle-l
Other related posts:
