Oracle Table Space

Create a dictionary-managed tablespace

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, unable to create a dictionary-managed tablespace
Since 9.2, Oracle does not allow the creation of a dictionary-managed tablespace when the table space for system is local, and the extent management is removed dictionary

View Table Spaces

select tablespace_name,block_size,extent_management,segment_space_management from dba_tablespaces;

View tablespace files

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

To create a locally managed table space

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

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Oracle Table Space