批改oracle数据存储文件路径

2012-07-15

修改oracle数据存储文件路径shutdown immediate//停数据库cp /OPT/oracle/oradata/wad113/iread01.dbf /ho

修改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;