oracle表空间满了怎么办?
现在向大家推荐一种比较实用的方法!
建立一个中转临时表空间:
1,>create temporary tablespace temp2
tempfile 'D:\oracle\oradata\test\temp2.dbf' size 512M
reuse autoextend on next 100M maxsize 2048M;
2, >alter database default temporary tablespace temp2;
3, >drop tablespace temp including contents and datafiles;
重新建立一个新的临时表空间:
1, >create temporary tablespace temp
tempfile 'D:\oracle\oradata\test\temp01.dbf' size 512M
reuse autoextend on next 100M maxsize 2048M;
2, >alter database default temporary tablespace temp;
3, >drop tablespace temp2 including contents and datafiles;
一切OK!
现在向大家推荐一种比较实用的方法!
建立一个中转临时表空间:
1,>create temporary tablespace temp2
tempfile 'D:\oracle\oradata\test\temp2.dbf' size 512M
reuse autoextend on next 100M maxsize 2048M;
2, >alter database default temporary tablespace temp2;
3, >drop tablespace temp including contents and datafiles;
重新建立一个新的临时表空间:
1, >create temporary tablespace temp
tempfile 'D:\oracle\oradata\test\temp01.dbf' size 512M
reuse autoextend on next 100M maxsize 2048M;
2, >alter database default temporary tablespace temp;
3, >drop tablespace temp2 including contents and datafiles;
一切OK!