Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2014/06/20(10:40) from 210.93.7.51 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 2887 , ÁÙ¼ö : 20 |
[Oracle] Å×ÀÌºí½ºÆäÀ̽º datafile Ãß°¡ or size ´Ã¸®±â(resize) |
---|
# su - oracle [oracle@dbs ~]$ sqlplus SQL*Plus: Release 11.2.0.4.0 Production on Fri Jun 20 10:39:21 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Enter user-name: /as sysdba Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production SQL> alter database datafile '/oracle/oradata/myplace/system01.dbf' resize 2500M; SQL> select * from dba_tablespaces where tablespace_name='SYSTEM'; SQL> alter tablespace [table_space_name] add datafile '/oracle/oradata/myplace/my_data02.dbf' size 1024M; |