- 论坛徽章:
- 0
|
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;
|
|