| Oracle/MySQL 관련 게시판 |
|---|
| 2014/06/20(10:40) from 210.93.7.51 | |
| 작성자 : 주인장 | 조회수 : 2885 , 줄수 : 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; |
|
|