1. å建æµè¯è¡¨ç©ºé´
sys@ORCL>create tablespace aaa datafile '/11g/app/oracle/oradata/ORCL/aaa bbb.dbf' size 10m;
Tablespace created.
2. å°è¡¨ç©ºé´offline
sys@ORCL>alter tablespace aaa offline;
Tablespace altered.
3. ç´æ¥ä¿®æ¹æ°æ®æ件ååæ¥é
sys@ORCL>alter database rename file '/11g/app/oracle/oradata/ORCL/aaa bbb.dbf' to '/11g/app/oracle/oradata/ORCL/aaabbb.dbf';
alter database rename file '/11g/app/oracle/oradata/ORCL/aaa bbb.dbf' to '/11g/app/oracle/oradata/ORCL/aaabbb.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 8 - new file '/11g/app/oracle/oradata/ORCL/aaabbb.dbf' not
found
ORA-01110: data file 8: '/11g/app/oracle/oradata/ORCL/aaa bbb.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
4. ä¿®æ¹æä½ç³»ç»çº§æ°æ®æ件åå
[oracle@test ORCL]$ mv aaa\ bbb.dbf aaabbb.dbf
[oracle@test ORCL]$ ls
aaabbb.dbf redo01.log SYSAUX01.DBF TEST.DBF wmis01.dbf
control01.ctl redo02.log SYSTEM01.DBF UNDOTBS01.DBF
EXAMPLE01.DBF redo03.log temptbs01.dbf USERS01.DBF
5. ä¿®æ¹æ°æ®åºçº§æ°æ®æ件åå
sys@ORCL>alter database rename file '/11g/app/oracle/oradata/ORCL/aaa bbb.dbf' to '/11g/app/oracle/oradata/ORCL/aaabbb.dbf';
Database altered.
6. å°æ°æ®æ件online
sys@ORCL>alter tablespace aaa online;
Tablespace altered.
sys@ORCL>select name from v$datafile where file#=8;
NAME
温馨提示:答案为网友推荐,仅供参考