Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2014/07/23(10:34) from 210.93.7.52 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 2819 , ÁÙ¼ö : 14 |
[Oracle] Non System Å×ÀÌºí½ºÆäÀ̽º's µ¥ÀÌÅÍÆÄÀÏ À̸§º¯°æ |
---|
1. oldÆÄÀÏÀ» new ÆÄÀÏ·Î º¹»ç¸¦ Çسõ´Â´Ù. copy link_ts.dbf link_ts_01.dbf 2. Å×ÀÌºí½ºÆäÀ̽º¸¦ Offline ½ÃŲ´Ù. SQL> alter tablespace link_ts offline; 3. µ¥ÀÌÅÍÆÄÀÏ À̸§À» º¯°æÇÑ´Ù. SQL> alter database rename file '°æ·Î/link_ts.dbf' to '°æ·Î/link_ts_01.dbf' 4. Å×ÀÌºí½ºÆäÀ̽º¸¦ Online ½ÃŲ´Ù. SQL> alter tablespade link_ts online; 5. Old ÆÄÀÏÀ» »èÁ¦ÇÑ´Ù. delete link_ts.dbf; |