SUNDB Tablespace & User 생성

// sysdba 계정 접속

[qcubic@symphony ~]$ gsql --as sysdba

// tablespace and datafile 확인

gSQL> select * from x$tablespace;

gSQL> select * from x$datafile;

// data tablespace 생성

gSQL> create tablespace TBS_DATA_USR datafile 'tbs_data_usr_01.dbf' size 10m;

Tablespace created.

// data tablespace 추가

gSQL> alter tablespace TBS_DATA_USR add datafile 'tbs_data_usr_02.dbf' size 10m;

Tablespace altered.

// temp tablespace 생성

gSQL> create temporary tablespace TBS_TEMP_USR memory 'TBS_TEMP_USR_01' size 10m;

Tablespace created.

// temp tablespace 추가

gSQL> alter tablespace TBS_TEMP_USR add memory 'TBS_TEMP_USR_02' size 10m;

Tablespace altered.

// id: orange / pw: orange 계정 생성하고, tablespace 지정

gSQL> create user orange identified by orange default tablespace TBS_DATA_USR temporary tablespace TBS_TEMP_USR;

// orange 계정에 권한 부여

gSQL> grant all privileges on database to orange;

Grant succeeded.

// 신규 생성한 orange 계정으로 접속

[qcubic@symphony ~]$ gsql orange orange;