创建临时表空间:
SQL> CREATE TEMPORARY TABLESPACE temp TEMPFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\temp01.dbf' SIZE 20M ;
SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;
更新其他用户的临时表空间指向:
1)用pl/sql developer 的sys用户登陆并运行sql window窗口:
select 'alter user '|| username ||' temporary tablespace temp; ' from dba_users;
2)用pl/sql developer 的sys用户登陆并运行command window窗口:
将上面一步结果拷贝运行;
删除系统的临时表空间tmp:
SQL> drop tablespace tmp INCLUDING CONTENTS AND DATAFILES;
检查操作效果:
select * from dba_data_files;
select * from dba_users;
select * from dba_tablespaces;
SQL> CREATE TEMPORARY TABLESPACE temp TEMPFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\temp01.dbf' SIZE 20M ;
SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;
更新其他用户的临时表空间指向:
1)用pl/sql developer 的sys用户登陆并运行sql window窗口:
select 'alter user '|| username ||' temporary tablespace temp; ' from dba_users;
2)用pl/sql developer 的sys用户登陆并运行command window窗口:
将上面一步结果拷贝运行;
删除系统的临时表空间tmp:
SQL> drop tablespace tmp INCLUDING CONTENTS AND DATAFILES;
检查操作效果:
select * from dba_data_files;
select * from dba_users;
select * from dba_tablespaces;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/444614/viewspace-478298/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/444614/viewspace-478298/