ORA-01110 表空间 临时表空间

sqlplus /as sysdba;

shutdown immediate;

startup mount

//修改表空间路径

alter tablespace test_data rename datafile 'D:/oracle/test_data.dbf' to 'E:/oracle/test_data.dbf'; alter database open;

//删除临时表空间

drop tablespace test_temp;

//创建临时表空间

create temporary tablespace test_temp tempfile 'E:\oracle\test_temp.dbf' size 100m autoextend on next 100m maxsize 1024m extent management local;

//赋予用户 alter user test temporary tablespace test_temp;