修改oracle数据存储文件路径

shutdown immediate //停数据库

cp /OPT/oracle/oradata/wad113/iread01.dbf /home/oradata //复制数据文件到另一个分区下

startup mount //启动数据库

Alter DATABASE RENAME FILE '/OPT/oracle/oradata/wad113/iread01.dbf' TO '/home/oradata/iread01.dbf' ';// 修改关联

alter database open;

quit;