{表領域、データファイル}各種表領域を作成

     ローカル管理表領域
     bigfile表領域
     圧縮された表領域
     一時表領域
     undo表領域
     非標準ブロックサイズの表領域
     OMFの場合

https://docs.oracle.com/cd/F19136_01/admin/managing-tablespaces.html#GUID-9A3CE861-80FE-4813-B496-287B69A79C46

sqlplus system/oracle@pdb11

select * from dba_data_files;
select * from dba_temp_files;
select * from dba_tablespaces;
select * from v$tablespace;

create tablespace tbsa datafile '/oradata/orcl/pdb11/tbsa01.dbf' 
 size 10M autoextend on maxsize unlimited;

create tablespace tbsb datafile '/oradata/orcl/pdb11/tbsb01.dbf' 
 size 10M autoextend on maxsize unlimited 
 extent management local autoallocate
 segment space management auto;

create tablespace tbsc datafile '/oradata/orcl/pdb11/tbsc01.dbf' 
 size 10M autoextend on maxsize unlimited 
 extent management local uniform size 1M
 segment space management auto;

create tablespace tbsd datafile '/oradata/orcl/pdb11/tbsd01.dbf' 
 size 10M autoextend on maxsize unlimited 
 extent management local 
 segment space management auto;

 

create tablespace tbse datafile '/oradata/orcl/pdb11/tbse01.dbf' 
 size 10M autoextend on maxsize unlimited 
 extent management local autoallocate
 segment space management manual;

 

create tablespace tbsf datafile '/oradata/orcl/pdb11/tbsf01.dbf' 
 size 10M autoextend off;

create tablespace tbsg datafile '/oradata/orcl/pdb11/tbsg01.dbf' 
 size 10M autoextend on next 1M maxsize 1G;

 

-- bigfile表領域

create bigfile tablespace tbsh datafile '/oradata/orcl/pdb11/tbsh01.dbf' 
 size 10M autoextend on maxsize unlimited;

-- 圧縮された表領域

create tablespace tbsi datafile '/oradata/orcl/pdb11/tbsi01.dbf' 
 size 10M autoextend on maxsize unlimited
 default compress for oltp;

-- 一時表領域

create temporary tablespace tempa tempfile '/oradata/orcl/pdb11/tempa01.dbf' 
 size 10M autoextend on maxsize unlimited;

-- undo表領域

create undo tablespace undoa datafile '/oradata/orcl/pdb11/undoa01.dbf' 
 size 10M autoextend on maxsize unlimited;

-- 非標準ブロックサイズの表領域

conn / as sysdba

alter system set db_16k_cache_size=10M;

conn system/oracle@pdb11

create tablespace tbsj datafile '/oradata/orcl/pdb11/tbsj01.dbf' 
 size 10M autoextend on
 blocksize 16k;

-- OMFの場合
conn / as sysdba

show parameter DB_CREATE
alter system set db_create_file_dest='/oradata/orcl';

conn system/oracle@pdb11

create tablespace tbsk DATAFILE size 10M autoextend off;

create bigfile tablespace tbsl DATAFILE size 10M autoextend off;