[Oracle] 테이블스페이스 늘리기

C:\Documents and Settings\Administrator>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on 목 Mar 12 15:40:45 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

다음에 접속됨:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production

SQL> select file_name, tablespace_name, bytes
2 from dba_data_files
3 where tablespace_name = 'KJ_PORTAL_DATA';

FILE_NAME TABLESPACE_NAME BYTES
-------------------------------------------------------------------------------- ------------------------------ ----------
D:\ORACLE\ORADATA\KJPORTAL\KJ_PORTAL_DATA.ORA KJ_PORTAL_DATA 104857600

SQL> alter database datafile 'D:\ORACLE\ORADATA\KJPORTAL\KJ_PORTAL_DATA.ORA' resize 4096M;

데이타베이스가 변경되었습니다.

SQL>