Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2002/09/25(21:03) from 218.149.64.230 | |
ÀÛ¼ºÀÚ : °ÁÙ±â (jkkang65@hanmail.net) | Á¶È¸¼ö : 4035 , ÁÙ¼ö : 8 |
[Oracle] Table Space(Å×ÀÌºí½ºÆäÀ̽º) ¿¡¼ Datafile À̸§ º¯°æ |
---|
SQL> alter tablespace temp offline; ¸ÕÀú OS¿¡¼ ÆÄÀÏÀ̸§ º¯°æ SQL> alter tablespace temp rename datafile '$ORACLE_HOME/oradata/ORA817/temp.dbs' to '$ORACLE_HOME/oradata/ORA817/temp.dbf' SQL> alter tablespace temp online; |