oracle表空間

oracle表空間

創建字典管理的表空間

create tablespace james datafile '/opt/oradata/orcl/james01.dbf' size 50 M,
       '/opt/oradata/orcl/james02.dbf' size 50 M 
        minimum extent 50k extent management dictionary
        default storage (initial 50k next 50k maxextents 100 pctincrease 0);

ORA-12913,無法創建字典管理的表空間
因為9.2開始，如果SYSTEM的表空間為LOCAL本地管理，ORACLE不允許再創建字典管理的表空間,此時要去掉extent management dictionary

查看表空間

select tablespace_name,block_size,extent_management,segment_space_management from dba_tablespaces;

查看表空間文件

select file_id,file_name,tablespace_name from dba_data_files order by file_id;

創建本地管理的表空間

create tablespace james_index 
 datafile '/opt/oradata/orcl/james_index.dbf' size 50 M 
    extent management local
    uniform size 1M