Temporary tablespace 생성 & default temporary tablespace 지정

현재 temporary tablespace 설정 확인

 

  SQL> select  tablespace_name, bytes, file_name

           from dba_temp_files;

  SQL> select *

           from database_properties

           where property_name like '%TEMP%';

 

temporary tablespace 생성 & default temporary tablespace 지정

 

  SQL> create temporary tablespace tmp

           tempfile '/home/oracle/oradata/orcl/tmp01.dbf' size 10m;

 

  SQL> select tablespace_name, bytes, file_name

           from dba_temp_files;

          

           tablespace_name        bytes           file_name

           ----------------        ---------      --------------------------------------

            TMP                         10485760        /home/oracle/oradata/orcl/tmp01.dbf

            TEMP                       20971520        /home/oracle/oradata/orcl/temp01.dbf

 

  SQL> alter databse default temporary tablespace tmp;

 

  SQL>  select *

            from database_properties

            where property_name like '%TEMP%';

[출처] Temporary tablespace 생성 & default temporary tablespace 지정|작성자 초수키