non-system datafile Àç¹èÄ¡ ¹æ¹ý
ÀÛ¼ºÀÚ °ü¸®ÀÚ ÀÛ¼º½Ã°£ 2016-02-13 18:05:03
 

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


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦