/* ========================================================
NAME : RF114_Community
DATE : 2016.03.15
E-MAIL : rf114@daum.net
URL : http://www.rf114.com

[LISENCE]
This program is free web source from RF114.com
This is not commercial lisence and as modify as possiable
to this contents include.
======================================================== */

SELECT NAME, DB_UNIQUE_NAME FROM v$database;

SELECT instance FROM v$thread;

SELECT tablespace_name, status from dba_tablespaces;

SELECT status,enabled, t.name ,d.name FROM V$DATAFILE d, V$TABLESPACE t WHERE t.ts#=d.ts#;

-----------------------------------------------------------

TABLESPACE_NAME                STATUS
------------------------------ ---------
SYSTEM                         ONLINE
SYSAUX                         ONLINE
UNDOTBS1                       ONLINE
TEMP                           ONLINE
USERS                          ONLINE
TIRS_P                         ONLINE
TMOS_P                         ONLINE
TPAC_P                         ONLINE
TPIC_P                         ONLINE
TPMC_P                         ONLINE
TPRC_P                         ONLINE

TABLESPACE_NAME                STATUS
------------------------------ ---------
TRDO_P                         ONLINE
TSCC_P                         ONLINE
TSRA_P                         ONLINE
XIRS_P                         ONLINE
XMOS_P                         ONLINE
XPAC_P                         ONLINE
XPIC_P                         ONLINE
XPMC_P                         ONLINE
XPRC_P                         ONLINE
XRDO_P                         ONLINE
XSCC_P                         ONLINE

TABLESPACE_NAME                STATUS
------------------------------ ---------
XSRA_P                         ONLINE
TIRS                           ONLINE
TMOS                           ONLINE
TPAC                           ONLINE
TPIC                           ONLINE
TPMC                           ONLINE
TRDO                           ONLINE
TSCC                           ONLINE
TSRA                           ONLINE
XIRS                           ONLINE
XMOS                           ONLINE

TABLESPACE_NAME                STATUS
------------------------------ ---------
XPAC                           ONLINE
XPIC                           ONLINE
XPMC                           ONLINE
XRDO                           ONLINE
XSCC                           ONLINE
XSRA                           ONLINE
KITESHIELD                     ONLINE

40 rows selected.

-----------------------------------------------------------

Ctrl + C
service sfilterd start 
À¥¿¡¼­ mount

su - oracle
sqlplus "/as sysdba"

alter tablespace TIRS offline;
alter tablespace TMOS offline;
alter tablespace TPAC offline;
alter tablespace TPIC offline;
alter tablespace TPMC offline;
alter tablespace TRDO offline;
alter tablespace TSCC offline;
alter tablespace TSRA offline;
alter tablespace XIRS offline;
alter tablespace XMOS offline;
alter tablespace XPAC offline;
alter tablespace XPIC offline;
alter tablespace XPMC offline;
alter tablespace XRDO offline;
alter tablespace XSCC offline;
alter tablespace XSRA offline;
alter tablespace XPAC_P offline;
alter tablespace TIRS_P offline;
alter tablespace TMOS_P offline;
alter tablespace TPAC_P offline;
alter tablespace TPIC_P offline;
alter tablespace TPMC_P offline;
alter tablespace TPRC_P offline;
alter tablespace TRDO_P offline;
alter tablespace TSCC_P offline;
alter tablespace TSRA_P offline;
alter tablespace XIRS_P offline;
alter tablespace XMOS_P offline;
alter tablespace XPAC_P offline;
alter tablespace XPIC_P offline;
alter tablespace XPMC_P offline;
alter tablespace XPRC_P offline;
alter tablespace XRDO_P offline;
alter tablespace XSCC_P offline;
alter tablespace XSRA_P offline;
SELECT tablespace_name, status from dba_tablespaces;
SELECT status,enabled, t.name ,d.name FROM V$DATAFILE d, V$TABLESPACE t WHERE t.ts#=d.ts#;

Ä¿¸Çµå â¿¡¼­

mv /D1/oradata/* /mnt/hospital/
cp ·Î ÇÒ °æ¿ì ¼ÒÀ¯±Ç º¯°æ(chown -R oracle.oinstall /MNT_POS)

oracle - sqlplus "/as sysdba"

alter tablespace TIRS
rename datafile '/mnt/hospital/TIRS01.dbf'
to '/D2/oradata/TIRS01.dbf';

alter tablespace TMOS
rename datafile '/mnt/hospital/TMOS01.dbf'
to '/D2/oradata/TMOS01.dbf';

alter tablespace TPAC
rename datafile '/mnt/hospital/TPAC01.dbf'
to '/D2/oradata/TPAC01.dbf';

alter tablespace TPIC
rename datafile '/mnt/hospital/TPIC01.dbf'
to '/D2/oradata/TPIC01.dbf';

alter tablespace TPMC
rename datafile '/mnt/hospital/TPMC01.dbf'
to '/D2/oradata/TPMC01.dbf';

alter tablespace TRDO
rename datafile '/mnt/hospital/TRDO01.dbf'
to '/D2/oradata/TRDO01.dbf';

alter tablespace TSCC
rename datafile '/mnt/hospital/TSCC01.dbf'
to '/D2/oradata/TSCC01.dbf';

alter tablespace TSRA
rename datafile '/mnt/hospital/TSRA01.dbf'
to '/D2/oradata/TSRA01.dbf';

alter tablespace XIRS
rename datafile '/mnt/hospital/XIRS01.dbf'
to '/D2/oradata/XIRS01.dbf';

alter tablespace XMOS
rename datafile '/mnt/hospital/XMOS01.dbf'
to '/D2/oradata/XMOS01.dbf';

alter tablespace XPAC
rename datafile '/mnt/hospital/XPAC01.dbf'
to '/D2/oradata/XPAC01.dbf';

alter tablespace XPIC
rename datafile '/mnt/hospital/XPIC01.dbf'
to '/D2/oradata/XPIC01.dbf';

alter tablespace XPMC
rename datafile '/mnt/hospital/XPMC01.dbf'
to '/D2/oradata/XPMC01.dbf';

alter tablespace XRDO
rename datafile '/mnt/hospital/XRDO01.dbf'
to '/D2/oradata/XRDO01.dbf';

alter tablespace XSCC
rename datafile '/mnt/hospital/XSCC01.dbf'
to '/D2/oradata/XSCC01.dbf';

alter tablespace XSRA
rename datafile '/D2/oradata/XSRA01.dbf'
to '/mnt/hospital/XSRA01.dbf';



alter tablespace XPAC_P
rename datafile '/D1/oradata/XPAC02.dbf'
to '/mnt/hospital/XPAC02.dbf';

alter tablespace TIRS_P
rename datafile '/D1/oradata/TIRS01.dbf'
to '/mnt/hospital/TIRS01.dbf';

alter tablespace TMOS_P
rename datafile '/D1/oradata/TMOS01.dbf'
to '/mnt/hospital/TMOS01.dbf';

alter tablespace TPAC_P
rename datafile '/D1/oradata/TPAC01.dbf'
to '/mnt/hospital/TPAC01.dbf';

alter tablespace TPAC_P
rename datafile '/D1/oradata/TPAC02.dbf'
to '/mnt/hospital/TPAC02.dbf';

alter tablespace TPIC_P
rename datafile '/D1/oradata/TPIC01.dbf'
to '/mnt/hospital/TPIC01.dbf';

alter tablespace TPMC_P
rename datafile '/D1/oradata/TPMC01.dbf'
to '/mnt/hospital/TPMC01.dbf';

alter tablespace TPRC_P
rename datafile '/D1/oradata/TPRC01.dbf'
to '/mnt/hospital/TPRC01.dbf';

alter tablespace TRDO_P
rename datafile '/D1/oradata/TRDO01.dbf'
to '/mnt/hospital/TRDO01.dbf';

alter tablespace TSCC_P
rename datafile '/D1/oradata/TSCC01.dbf'
to '/mnt/hospital/TSCC01.dbf';

alter tablespace TSRA_P
rename datafile '/D1/oradata/TSRA01.dbf'
to '/mnt/hospital/TSRA01.dbf';

alter tablespace XIRS_P
rename datafile '/D1/oradata/XIRS01.dbf'
to '/mnt/hospital/XIRS01.dbf';

alter tablespace XMOS_P
rename datafile '/D1/oradata/XMOS01.dbf'
to '/mnt/hospital/XMOS01.dbf';

alter tablespace XPAC_P
rename datafile '/D1/oradata/XPAC01.dbf'
to '/mnt/hospital/XPAC01.dbf';

alter tablespace XPIC_P
rename datafile '/D1/oradata/XPIC01.dbf'
to '/mnt/hospital/XPIC01.dbf';

alter tablespace XPMC_P
rename datafile '/D1/oradata/XPMC01.dbf'
to '/mnt/hospital/XPMC01.dbf';

alter tablespace XPRC_P
rename datafile '/D1/oradata/XPRC01.dbf'
to '/mnt/hospital/XPRC01.dbf';

alter tablespace XRDO_P
rename datafile '/D1/oradata/XRDO01.dbf'
to '/mnt/hospital/XRDO01.dbf';

alter tablespace XSCC_P
rename datafile '/D1/oradata/XSCC01.dbf'
to '/mnt/hospital/XSCC01.dbf';

alter tablespace XSRA_P
rename datafile '/D1/oradata/XSRA01.dbf'
to '/mnt/hospital/XSRA01.dbf';


alter tablespace TIRS online;
alter tablespace TMOS online;
alter tablespace TPAC online;
alter tablespace TPIC online;
alter tablespace TPMC online;
alter tablespace TRDO online;
alter tablespace TSCC online;
alter tablespace TSRA online;
alter tablespace XIRS online;
alter tablespace XMOS online;
alter tablespace XPAC online;
alter tablespace XPIC online;
alter tablespace XPMC online;
alter tablespace XRDO online;
alter tablespace XSCC online;
alter tablespace XSRA online;
alter tablespace XPAC_P online;
alter tablespace TIRS_P online;
alter tablespace TMOS_P online;
alter tablespace TPAC_P online;
alter tablespace TPIC_P online;
alter tablespace TPMC_P online;
alter tablespace TPRC_P online;
alter tablespace TRDO_P online;
alter tablespace TSCC_P online;
alter tablespace TSRA_P online;
alter tablespace XIRS_P online;
alter tablespace XMOS_P online;
alter tablespace XPAC_P online;
alter tablespace XPIC_P online;
alter tablespace XPMC_P online;
alter tablespace XPRC_P online;
alter tablespace XRDO_P online;
alter tablespace XSCC_P online;
alter tablespace XSRA_P online;
SELECT tablespace_name, status from dba_tablespaces;
SELECT status,enabled, t.name ,d.name FROM V$DATAFILE d, V$TABLESPACE t WHERE t.ts#=d.ts#;