更换临时表空间TEMP

最新推荐文章于 2025-09-11 20:53:34 发布

转载最新推荐文章于 2025-09-11 20:53:34 发布 · 69 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/wu1314421/p/4578732.html

文章标签：

#数据库

SQL>
SQL> create temporary tablespace temp2 tempfile '/URP/oracle/oradata/urpjw/temp001.dbf' size 170M;

Tablespace created

SQL> alter database default temporary tablespace temp2;

Database altered

SQL> drop tablespace temp
2 ;

Tablespace dropped

SQL>
SQL>
SQL>
SQL>
SQL> create temporary tablespace temp tempfile '/URP/oracle/oradata/urpjw/temp01.dbf' size 1024M;

Tablespace created

SQL> alter database default temporary tablespace temp;

Database altered

SQL> drop tablespace temp2;

Tablespace dropped