テーブルスペース作成

• Oracle

create tablespace tbs1 datafile '/u01/app/oracle/oradata/orcl/tbs1.dbf' size 10M autoextend on maxsize unlimited;

• MySQL

(5.7)からInnoDBでも作成可能

select * from INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES;

CREATE TABLESPACE `tbs1` ADD DATAFILE 'tbs1.ibd' ENGINE=INNODB;

• PostgreSQL

\db+

create tablespace tbs1 owner postgres location '/var/lib/pgsql/9.4/data';

• SQL Server

--ファイルグループ

ALTER DATABASE [test] ADD FILEGROUP [fg1]

ALTER DATABASE [test] ADD FILE
(NAME = N'fg11'
,FILENAME = N'E:\DATA\fg11.ndf'
) TO FILEGROUP [fg1]

USE [test]
CREATE TABLE [fgtest](
id INT,
name NVARCHAR(20)
) ON [fg1]
go