01.오라클/002.DB 마이그레이션
[오라클]system tablespace rename
redkite
2013. 2. 23. 15:50
1. SQL> Shutdown immediate
2. $ cp /oracle/maxprd1/system01.dbf to /oracle/maxprd1/maxlive/system01.dbf
3. SQL> startup mount
4. SQL> alter database rename file '/oracle/maxprd1/system01.dbf' to '/oracle/maxprd1/maxlive/system01.dbf';
5. SQL> alter database open.
6. $ rm /oracle/maxprd1/system01.dbf