[altibase]create or drop table space

• directory 생성

mkdir -p /alti_dbs_disk0/disk_dat
mkdir -p /alti_dbs_disk0/disk_idx

mkdir -p /alti_dbs_mem0/mem_dat_0/

mkdir -p /alti_dbs_mem1/mem_dat_1/

• DISK DATA 생성

CREATE DISK DATA TABLESPACE TS_TMP_DISK_DAT

DATAFILE
'/alti_dbs_disk0/disk_dat/TMP_disk_dat_01.dbf'
SIZE 1G
AUTOEXTEND OFF;

• DISK IDX 생성

CREATE DISK DATA TABLESPACE TS_TMP_DISK_IDX
DATAFILE
'/alti_dbs_disk0/disk_idx/TMP_disk_idx_01.dbf'
SIZE 1G
AUTOEXTEND OFF

• MEM DATA 생성

CREATE MEMORY TABLESPACE TS_TMP_MEM_DAT
      SIZE 64M 
      AUTOEXTEND ON NEXT 20M MAXSIZE 2G 
      CHECKPOINT PATH '/alti_dbs_mem0/mem_dat_0/',
'/alti_dbs_mem1/mem_dat_1/';

또는

CREATE MEMORY TABLESPACE TS_SPI_MEM_DAT
      SIZE 300M 
      AUTOEXTEND ON 

• drop tablespace

DROP TABLESPACE TS_TMP_MEM_DAT INCLUDING CONTENTS CASCADE CONSTRAINTS;

DROP TABLESPACE TS_TMP_DISK_IDX INCLUDING CONTENTS CASCADE CONSTRAINTS;

DROP TABLESPACE TS_TMP_DISK_DAT INCLUDING CONTENTS CASCADE CONSTRAINTS;