参考: How do I rename a data file? http://www.jlcomp.demon.co.uk/faq/rename_datafile.html SVRMGR> connect sys/oracle as sysdba SVRMGR> alter tablespace app_data offline; SVRMGR> alter tablespace app_date rename datafile '/u01/oracle/U1/data01.dbf ' TO '/u02/oracle/U1/data04.dbf ' ; SVRMGR> alter tablespace app_data online;或者 > svrmgrl SVRMGR> connect sys/oracle as sysdba; SVRMGR> startup mount U1; SVRMGR> alter database rename file '/u01/oracle/U1/data01.dbf ' TO '/u02/oracle/U1/data04.dbf ' ; SVRMGR> alter database open; ------------------------------------------------------------------------------ Blog: http://blog.csdn.net/tianlesoftware 网上资源: http://tianlesoftware.download.csdn.net 相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 群:62697716(满); DBA2 群:62697977
alter tablespace users rename datafile‘d:\product\10.1.0\oradata\aaa\user01.dbf' to ‘d:\product\10.1.0\oradata\aaa\user02.dbf ‘这句操作前提是 user02.dbf必须存在 然后改控制文件
alter tablespace users rename datafile‘d:\product\10.1.0\oradata\aaa\user01.dbf' to ‘d:\product\10.1.0\oradata\aaa\user02.dbf --重在更新控制文件中user01.dbf的位置
sql>startup mount;
sql>alter database rename datafile 'd:\product\10.1.0\oradata\aaa\user01.dbf' to 'd:\product\10.1.0\oradata\aaa\user02.dbf'
参考:
How do I rename a data file?
http://www.jlcomp.demon.co.uk/faq/rename_datafile.html
SVRMGR> connect sys/oracle as sysdba
SVRMGR> alter tablespace app_data offline;
SVRMGR> alter tablespace app_date rename datafile '/u01/oracle/U1/data01.dbf ' TO '/u02/oracle/U1/data04.dbf ' ;
SVRMGR> alter tablespace app_data online;或者
> svrmgrl
SVRMGR> connect sys/oracle as sysdba;
SVRMGR> startup mount U1;
SVRMGR> alter database rename file '/u01/oracle/U1/data01.dbf ' TO '/u02/oracle/U1/data04.dbf ' ;
SVRMGR> alter database open;
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
alter tablespace users rename datafile‘d:\product\10.1.0\oradata\aaa\user01.dbf' to ‘d:\product\10.1.0\oradata\aaa\user02.dbf
--重在更新控制文件中user01.dbf的位置