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..
DataBase/Oracle
2010. 5. 18. 18:44