oracle 更改datafile路径

SQL> shut abort                              停止数据库
ORACLE instance shut down.

SQL> startup mount                           启动数据库mount模式
ORACLE instance started.

Total System Global Area 2304909312 bytes
Fixed Size                  2215464 bytes
Variable Size            2214592984 bytes
Database Buffers           67108864 bytes
Redo Buffers               20992000 bytes
Database mounted.

 
SQL> select name from v$datafile;              查看datafile文件

[root@DB-Oracle-01 /]# chown -R oracle:oinstall /ora_new_data_dir/                       创建oracle权限目录

[root@DB-Oracle-01 /]# su - oracle
[oracle@DB-Oracle-01 ~]$ cp /old_data/system01.dbf /ora_new_data_dir/            拷贝到新的目录

SQL> alter database rename file '/old_data/system01.dbf' to '/ora_new_data_dir/ system01.dbf';   datafile重定向

Database altered.

SQL> alter database open;   打开数据库

Database altered.


SQL> select username,DEFAULT_TABLESPACE from dba_users;  查看用户名对应tablespace

SQL> desc dba_users;