Temp tablespace 사용법

 using by user.

--1. 만들기

S SYS> create temporary tablespace temp2;

Tablespace created.

 

--2. 적용.

S SYS> alter user hr temporary tablespace temp2;

User altered.

 

--3. 적용 확인

S SYS> select username, temporary_tablespace from dba_users where username='HR';

USERNAME                              TEMPORARY_TABLESPACE
------------------------------ ------------------------------
HR                                           TEMP2

 

 

--4. 사용중인 모든 temp t/s 목록

S SYS> select distinct temporary_tablespace from dba_users;

TEMPORARY_TABLESPACE
------------------------------
TEMP
TEMP2