1. datafileÀ» ¿ÀÇ »óÅ¿¡¼ Àç¹èÄ¡ ÇÑ´Ù.
SQL> connect system/manager
SQL> alter tablespace sample offline;
2. sample datafileÀ» À̵¿ÇÏ·Á´Â °÷À¸·Î º¹»ç
$ cp $HOME/dbs/sample01.dbf $HOME/disk4/sample01.bdf
3. sample datafile °æ·Î¸¦ rename ÇÑ´Ù.
SQL> alter tablespace sample RENAME datafile
'$HOME/dbs/sample01.dbf' TO '$HOME/disk4/sample01.bdf';
4. acess°¡ °¡´ÉÇϵµ·Ï tablespace¸¦ online
SQL> alter tablespace sample ONLINE;
5. Á¤»óÀûÀ¸·Î ÀÚ·á ÀÔ·ÂÀÌ µÇ´ÂÁö È®ÀÎ ÈÄ ÀÌÀü ÆÄÀÏÀº »èÁ¦ÇÑ´Ù.
SQL> !rm $HOME/dbs/sample01.dbf
|