extent management

extent management 有两种方式 extent management local ; extent management dictionary
默认的是local

每种也有两种大小增长方式:
uniform:默认为1M大小,在temp表空间里为默认的,但是不能被应用在undo表空间
autoallocate:

You can convert a tablespace from dictionary extent management to local extent management
and back with the Oracle-supplied PL/SQL package DBMS_SPACE_ADMIN. The SYSTEM
tablespace and any temporary tablespaces, however, cannot be converted from local to the
older style dictionary managem
两种extent管理方式是可以相互转换的,利用PL/SQL DBMS_SPACE_ADMIN
但是系统表空间和临时表空间不能从local管理转化到dictionary管理。

原文地址:https://www.cnblogs.com/lovewife/p/1427788.html