{"id":409,"date":"2013-09-27T18:55:28","date_gmt":"2013-09-28T03:55:28","guid":{"rendered":"\/blog\/?p=409"},"modified":"2023-09-21T09:38:52","modified_gmt":"2023-09-21T00:38:52","slug":"oracle-%ed%85%8c%ec%9d%b4%eb%b8%94%ec%8a%a4%ed%8e%98%ec%9d%b4%ec%8a%a4-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=409","title":{"rendered":"[oracle] \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc815\ub9ac"},"content":{"rendered":"\n

\uc6d0\uae00 : http:\/\/www.zetswing.com\/bbs\/board.php?bo_table=ORACLE_TIP&wr_id=22<\/a>
<\/p>

\n<\/span>


<\/span><\/font><\/strong><\/p>

\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4(TableSpace) \uc815\uc758<\/span><\/font><\/strong><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14\uc774 \uc800\uc7a5\ub418\ub294 \uacf5\uac04\uc785\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

\uc624\ub77c\ud074 \uc5d0\uc11c\ub294 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub77c\uace0 \ud574\uc11c \ud14c\uc774\ube14\uc774 \uc800\uc7a5\ub420 \uacf5\uac04\uc744 \uba3c\uc800 \ub9cc\ub4e4\uace0 \ub098\uc11c <\/span><\/font><\/p>\n<\/span>

\ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. <\/span><\/font>\uac01\uac01\uc758 \ud14c\uc774\ube14\uc744 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ubcc4\ub85c \ub098\ub204\uc5b4\uc11c \uad00\ub9ac\uc640 \ud37c\ud3ec\uba3c\uc2a4\uc758 <\/span><\/font><\/p>\n<\/span>

\ud5a5\uc0c1\uc744 \uac00\uc9c0\uace0 \uc624\ub294\uac83\uc785\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\uba74 \uc815\uc758\ub41c \uc6a9\ub7c9\ub9cc\ud07c \ubbf8\ub9ac \ud655\ubcf4\ud55c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 \uc0dd\uc131\ub418\uc5b4 <\/span><\/font><\/p>\n<\/span>

\uc9c0\uace0 \uc0dd\uc131\ub418\uc5b4\uc9c4 <\/span><\/font>\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud0c0\uac00 \uc800\uc7a5\ub429\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\uc608\ub97c \ub4e4\uba74 \ub9ce\uc740 \ub370\uc774\ud130\uac00 \uc313\uc77c \uac8c\uc2dc\ud310 \ud14c\uc774\ube14\uc740 \uae30\ubcf8\uc6a9\ub7c9 100\uba54\uac00 \uc790\ub3d9\ud655\uc7a5 10\uba54\uac00\ub85c <\/span><\/font><\/p>\n<\/span>

\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c <\/span><\/font>\ub9cc\ub4e4\uc5b4\uc11c \uadf8\uacf3\uc5d0 \uac8c\uc2dc\ud310 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4 \uc4f0\uba74 \uac8c\uc2dc\ud310 \ub370\uc774\ud130\ub294 \uadf8\uacf3\uc5d0 <\/span><\/font><\/p>\n<\/span>

100\uba54\uac00\uae4c\uc9c0 \ub370\uc774\ud130\uac00 \uc800\uc7a5\ub418\uace0 \uc6a9\ub7c9 \ucd08\uacfc\uc2dc \uc790\ub3d9\uc801\uc73c\ub85c 10\uba54\uac00\ub2e8\uc704\ub85c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 <\/span><\/font><\/p>\n<\/span>

\ud06c\uae30\ub294 \ud655\uc7a5\ub429\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\uc774\ub807\uac8c \uac01 \ud14c\uc774\ube14\uc758 \ud2b9\uc131\uc5d0 \ub9de\uac8c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \ub9cc\ub4e4\uc5b4 \ud65c\ub2f9\ud558\uba74 \uc88b\uc2b5\ub2c8\ub2e4. <\/span><\/font>\ubb3c\ub860 \uac01 <\/span><\/font><\/p>\n<\/span>

\uc2a4\ud0a4\ub9c8\ubcc4\ub85c \uc9c0\uc815\ub41c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \ub9cc\ub4e4\uc5b4 \uc368\uc57c \uad00\ub9ac\uc801\uce21\uba74\uc5d0\uc11c \ubb34\ucc99\uc774\ub098 \ud6a8\uc728\uc801\uc785\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

MySQL \uc5d0\uc11c\ub294 DB \uc2dc\uc2a4\ud15c \uad00\ub828\uc0ac\ud56d(\uc0ac\uc6a9\uc790 \uc815\ubcf4, DB\uc815\ubcf4)\uc744 \uac00\uc9c0\uace0 \uc788\ub294 \uac83\uc774 <\/span>mysql DB <\/span><\/strong><\/font><\/p>\n<\/span>

\ub77c\uba74 Oracle \uc5d0\uc11c\ub294 <\/span>system \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4<\/span><\/strong>\ub85c \uc774\ud574\ud558\uba74 \ub429\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\u203b \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c \ub9cc\ub4e4\uc9c0 \uc54a\uc73c\uba74 ORACLE\uc11c\ubc84\uac00 \uc790\ub3d9\uc73c\ub85c \ub9cc\ub4e4\uc5b4 \uc90d\ub2c8\ub2e4.<\/span><\/strong><\/font><\/p>\n<\/span><\/font><\/strong>



\uc77c\ubc18\uc801\uc778 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131 \uacfc\uc815<\/span><\/font><\/strong><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

1. SYS \uacc4\uc815\uc73c\ub85c \uc811\uc18d\ud574\uc11c Mytablespace\ub77c\ub294 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c \ub9cc\ub4ed\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

2. SYS \uacc4\uc815\uc5d0\uc11c SCOTT2 \uc720\uc800\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.( default tablespace\ub294 Mytablespace\ub85c \ub9cc\ub4ed\ub2c8\ub2e4)<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

3. SCOTT \uacc4\uc815\uc758 emp \ud14c\uc774\ube14\uc744 scott2 \uacc4\uc815\uc73c\ub85c \ubcf5\uc0ac \ud569\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

create table scott2.emp table space mytablespace as select * from scott.emp;<\/span><\/font><\/p>\n<\/span>

\uc774\ub807\uac8c \ud558\uba74 \uc131\uacf5\ud558\uac8c \ub429\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4(TableSpace) \uac1c\ub150<\/span><\/font><\/strong><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14\uc758 Data \ub97c Delete \ud558\uace0 Commit \ud558\uc5ec\ub3c4 Tablespace\uc758 \uc0ac\uc6a9\ub7c9\uc740 \ubcc0\ud558\uc9c0 \uc54a\uc74c<\/span><\/strong><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14\uc758 \ud06c\uae30\uac00 \ub298\uc5b4\ub098\uc11c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ud06c\uae30\uac00 \uc790\ub3d9\uc73c\ub85c \ub298\uc5b4\ub098\uac8c \uc124\uc815\ud55c \uc0c1\ud0dc\uc5d0\uc11c \ud14c\uc774\ube14\uc758 \ud06c\uae30\uac00 \uc904\uc5b4\ub4e4\uba74 \uc790\ub3d9\uc73c\ub85c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \ud06c\uae30\uac00 \uc904\uc5b4\ub4e4\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4. \uc774\ub54c\ub294 \uc0ac\uc6a9\uc790\uac00 \uc218\ub3d9\uc73c\ub85c \ud06c\uae30\ub97c \uc124\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub294 \ubbf8\ub9ac \uacf5\uac04\uc744 \uc7a1\uc544 \ub193\uc558\uc73c\ubbc0\ub85c \ud55c\ubc88 \ub298\uc5b4\ub09c \ub118\uc774 \ub370\uc774\ud0c0\uac00 \uc904\uc5c8\ub2e4\uace0 \n\ud574\uc11c \uc904\uc5b4\ub4e4\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. 10\uba85\uc774\uc11c \ub4e4\uc5b4\uac00\uae30 \uc704\ud574 \ubc29\uc744 \ud070\uac78 \uc7a1\uc558\ub2e4\uac00 10\uba85\uc774 \uc0b4\ub358 \ubc29\uc5d0\uc11c 3~4\uba85\uc774 \ub098\uac14\ub2e4\uace0 \ubc29\uc774 \uc904\uc5b4\ub4e4\uc9c4 \n\uc54a\ub294\ub2e4\uace0 \ubcf4\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\uc77c\ubc18\uc801\uc73c\ub85c scott\ub77c\ub294 \uc720\uc800\uac00 \uc0dd\uc131\ub418\uba74 \uae30\ubcf8\uc801 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc640 \ud15c\ud504\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 <\/span><\/font><\/p>\n<\/span>

\uc9c0\uc815\ub428\ub2c8\ub2e4. \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uba74 \uae30\ubcf8\uc801\uc778 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \uc800\uc7a5\ub418\uace0 \uadf8 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub294<\/span><\/font><\/p>\n<\/span>

(create tablespce \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 datafile '\uacbd\ub85c\/\ud30c\uc77c\uba85') \uc774\ub807\uac8c \ub9cc\ub4e4\uc5b4\uc9c4 \uacbd\ub85c\uc640 \ud30c\uc77c\uc5d0 <\/span><\/font><\/p>\n<\/span>

\ub0b4\uc6a9\uc774 \uc800\uc7a5\ub418\uc5b4 \uc9d1\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud604\uc7ac oracle db\uc758 \ub9cc\ub4e4\uc5b4\uc9c4 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ubcf4\uae30<\/span><\/font><\/strong><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

system \uc73c\ub85c \ub85c\uadf8\uc778 \ud574\uc11c select * from dba_tablespaces; \ucffc\ub9ac \uc2e4\ud589<\/span><\/font><\/p>\n<\/span>

\ud574\ub2f9 \uacc4\uc815\uc73c\ub85c \ub85c\uadf8\uc778\ud574\uc11c select distinct tablespace_name from user_tables; \ucffc\ub9ac \uc2e4\ud589<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\u203b <\/span>TABS<\/span><\/strong> \ub294 <\/span>USER_TABLES<\/span><\/strong> \uc758 \ub3d9\uc758\uc5b4\uc785\ub2c8\ub2e4. \ub450\uac1c\ub294 \uac19\uc740 \uac83\uc785\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ud3ec\ud568\ub41c \ud14c\uc774\ube14 \uc54c\uc544\ubcf4\uae30<\/span><\/font><\/strong><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

SELECT TABLESPACE_NAME, TABLE_NAME FROM USER_TABLES WHERE TABLESPACE_NAME = '\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uba85';<\/span><\/font><\/p>\n<\/span>

-- \ud574\ub2f9 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ud3ec\ud568\ub41c \ud14c\uc774\ube14 \uc815\ubcf4\ub97c \uc870\ud68c<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud604\uc7ac ORACLE\uc11c\ubc84\uc5d0 \ub9cc\ub4e4\uc5b4\uc838\uc788\ub294 TABLESPACE\ubcf4\uae30(SYSTEM\uacc4\uc815\uc5d0\uc11c \uc2e4\ud589)<\/span><\/font><\/strong><\/p>\n<\/span>

<\/strong> <\/span><\/p>\n<\/span>

SELECT file_name, tablespace_name, bytes, status FROM DBA_DATA_FILES;<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

FILE_NAME : datafile\uc758 \ubb3c\ub9ac\uc801\uc778 \uc704\uce58\uc640 \ud30c\uc77c\uba85\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/span>
TABLESPACE_NAME : \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \uc774\ub984\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/span>
BYTES : \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \ud06c\uae30\ub97c \uc54c\uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/span>
STATUS : \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \uc774\uc6a9 \uac00\ub2a5 \uc5ec\ubd80\ub97c \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud604\uc7ac \uacc4\uc815\uc5d0\uc11c \uc0ac\uc6a9\ud560\uc218 \uc788\ub294 \ud14c\uc774\ube14\uc758 \uc6a9\ub7c9 \uc870\ud68c<\/span><\/font><\/strong><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

SELECT * FROM USER_SEGMENTS;<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ubcc4 \uc0ac\uc6a9 \uac00\ub2a5\ud55c \uacf5\uac04\uc758 \ud655\uc778 <\/span><\/font><\/font><\/strong><\/p>\n<\/span>

<\/strong> <\/span><\/p>\n<\/span>

SELECT tablespace_name, SUM(bytes), MAX(bytes) <\/span><\/font><\/p>\n<\/span>

FROM DBA_FREE_SPACE <\/span><\/font><\/p>\n<\/span>

GROUP BY tablespace_name;<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

SUM\uc744 \uc0ac\uc6a9\ud55c \uc774\uc720\ub294\ud558\ub098\uc758 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \ubd84\uc0b0\ub418\uc5b4 \uc788\ub294 \uc5ec\uc720\uacf5\uac04\uc744 \ud569\ud55c \uac83\uc774\uba70, <\/span><\/font><\/p>\n<\/span>

MAX\ub97c \uc0ac\uc6a9\ud55c \uc774\uc720\ub294 \uc5ec\uc720 \uacf5\uac04\uc911 \uac00\uc7a5 \ud070 \uacf5\uac04\uc758 SIZE\ub97c \uc758\ubbf8 \ud569\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131\uba85\ub839<\/span><\/font><\/strong><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

CREATE TABLESPACE storm <\/span><\/font><\/p>\n<\/span>

DATAFILE 'C:\\ORACLE\\ORADATA\\app_data.dbf' SIZE 100M <\/span><\/font><\/p>\n<\/span>

DEFAULT STORAGE <\/span>
(<\/span><\/font><\/p>\n<\/span>

  INITIAL    10K<\/span>
  NEXT      10K<\/span>
  MINEXTENTS 2<\/span>
  MAXEXTENTS 50<\/span>
  PCTINCREASE 50<\/span><\/font><\/p>\n<\/span>

)<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\u203b \ucd94\ud6c4\uc5d0 \uc704\uc758 \ub370\uc774\ud0c0\ud06c\uae30(100M) \ubcf4\ub2e4 \ucee4\uc9c0\uba74 \ub370\uc774\ud0c0\ud06c\uae30\ub294 \uc218\ub3d9\uba85\ub839\uc73c\ub85c \ub298\ub9b4\uc218 \uc788\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\u203b \ub9cc\ub4e4\ub54c SIZE 100M \ub4a4\uc5d0<\/span><\/font> <\/span><\/strong>autoextend on next 10m maxsize 500 <\/span><\/strong><\/font>\uc635\uc158\uc744 \uc8fc\uba74 \uc6a9\ub7c9\uc774 FULL\ub85c \ucc28\uba74 \uc790\ub3d9\uc73c\ub85c \uc6a9\ub7c9\uc774 \uc99d\uac00 \ub429\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\u203b \ube44\uc2b7\ud55c \uc131\uaca9(\uc5f0\uad00\uc131)\uc758 \ud14c\uc774\ube14\uc744\uc740 \uac19\uc740 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub450\ub294\uac8c \uc88b\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\u203b \uc77c\ubc18\uc801\uc73c\ub85c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131\uc2dc SIZE\ub97c \uc548\uc8fc\uba74 \ub514\ud3f4\ud2b8\ub85c 2GB \ub85c \uc7a1\ud799\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\uc0dd\uc131\uba85\ub839 \uc124\uba85<\/span><\/strong><\/font><\/p>\n<\/span>

CREATE USER TEST3<\/span><\/font><\/p>\n<\/span>

IDENTIFIED BY TEST3<\/span><\/font><\/p>\n<\/span>

DEFAULT TABLESPACE ABC<\/span><\/font><\/p>\n<\/span>

TEMPORARY TABLESPACE TEMP<\/span><\/font><\/p>\n<\/span>

QUOTA UNLIMITED ON ABC;<\/span><\/font><\/p>\n<\/span>

\uc124\uba85<\/span><\/strong><\/font><\/p>\n<\/span>

test3\uacc4\uc815\uc740 \uae30\ubcf8\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294 abc\ub97c \uc0ac\uc6a9\ud558\uace0 <\/span><\/font><\/p>\n<\/span>

\ud15c\ud504(\uc18c\ud2b8\uc6a9)\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294 temp\ub97c \uc4f0\uace0 <\/span><\/font><\/p>\n<\/span>

abc\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \uc81c\ud55c\uc5c6\uc774 \uc0ac\uc6a9\uac00\ub2a5\ud558\ub2e4. <\/span>
<\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

-------------------------------------------------------------------------------------<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\u203b SCOTT \uacc4\uc815\uc758 \ud14c\uc774\ube14\uc740 SYSTEM \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

\u203b SYSTEM TABLESPACE \uc5d0\ub294 \ub3d9\uc801 \uc131\ub2a5 \ubdf0\ub098 \uae30\ud0c0 \uc2dc\uc2a4\ud15c \uad00\ub828 \uc911\uc694\ud55c \ud14c\uc774\ube14\uc774 \uc800\uc7a5\ub429\ub2c8\ub2e4.<\/span><\/font><\/p>\n<\/span>

\u203b SYSTEM TABLESPACE \uac00 FULL\uc774 \ub418\uba74 Oracle \uc11c\ubc84\uac00 \ub2e4\uc6b4\ub41c\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc218\uc815 \uba85\ub839<\/span><\/font><\/strong><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

ALTER DATABASE DATAFILE '\ub370\uc774\ud130\ud30c\uc77c\uacbd\ub85c' <\/span>AUTOEXTEND ON NEXT 100M<\/span><\/strong> MAXSIZE UNLIMITED;<\/span><\/font><\/p>\n<\/span>

-- \ud574\ub2f9 \ub370\uc774\ud130\ud30c\uc77c\uacbd\ub85c\uc5d0 \ud574\ub2f9\ud558\ub294 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \ud06c\uae30\uac00 FULL\uc774 \ub418\uba74 \uc790\ub3d9\uc73c\ub85c 100\uba54\uac00\uc529 \ub298\uc5b4\ub09c\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ub610\ub294<\/span><\/strong><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

ALTER TABLESPACE \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uba85 ADD DATAFILE '\ucd94\uac00\ud560\ub370\uc774\ud130\ud30c\uc77c\uba85' SIZE 1024M;  <\/span>
<\/font>-- \ud574\ub2f9 \ud14c\uc774\ube14\uc2a4\ud14c\uc774\uc2a4\uc758 \uc6a9\ub7c9\uc744 1024\uba54\uac00\ub85c \ubcc0\uacbd\ud55c\ub2e4.<\/span><\/font><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

** \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c \uc124\uc815 \uc548\ud558\uba74 \ub514\ud3f4\ud2b8\ub85c \uc7a1\ud788\ub098\uc694? <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ub97c \uc124\uc815 \ud558\uc9c0\uc54a\uace0 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uba74 \ubb34\ud55c\ub300\ub85c \ub370\uc774\ud0c0\uac00 \ub4e4\uc5b4\uac00\ub098\uc694?<\/span><\/p>\n<\/span>

\uc2a4\ud0a4\ub9c8 \uc0dd\uc131 \uc720\uc800\uc758 default tablespace\uc5d0 \uc0dd\uc131\uc774 \ub418\uace0, \ud574\ub2f9 \ub514\ud3f4\ud2b8 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uac00 \uc218\uc6a9 <\/span><\/p>\n<\/span>

\uac00\ub2a5\ud55c \uc601\uc5ed\uae4c\uc9c0 \ub370\uc774\ud0c0\uac00 \ub4e4\uc5b4\uac11\ub2c8\ub2e4.<\/span><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\ud2b9\uc815\uacc4\uc815\uc758 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131\uc2dc<\/span><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

SYSTEM\uacc4\uc815\uc5d0\uc11c \uc0dd\uc131\ud558\ub294\uac8c \ub9de\uc2b5\ub2c8\ub2e4. \ud639\uc740 \uc0dd\uc131 \uad8c\ud55c\uc744 \uac00\uc9c0\uace0 \uc788\ub294 \uacc4\uc815\uc5d0\uc11c \uc0dd\uc131\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4. \"\ud2b9\uc815\uacc4\uc815\uc758 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc778\uac74 \uc5b4\ub5bb\uac8c \uc544\ub294\uac74\uc9c0\" \ub77c\ub294 \uc9c8\ubb38\uc5d0 \ub300\ud55c \ub2f5. <\/span>
\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294 \ud2b9\uc815 \uacc4\uc815\uc5d0 \uc18d\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. <\/span>
\ub2e8\uc9c0 \uacc4\uc815\uc744 \ub9cc\ub4dc\uc2e4\ub54c \ub514\ud3f4\ud2b8 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c \uc9c0\uc815\ud558\uac8c \ub418\ub294\ub370 \uc544\ub9c8 \uadf8\uac83 \ub54c\ubb38\uc5d0 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 \ud2b9\uc815 \uacc4\uc815\uc5d0 \uc18d\ud574 \uc788\ub2e4\uace0 \uc0dd\uac01\ud558\uc2e0 \ubaa8\uc591\uc785\ub2c8\ub2e4. <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uac00 \uc65c \ud544\uc694\ud558\uace0 \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ub418\ub294 \uac74\uc9c0\ub294 \uac15\uc88c\ub97c \ud1b5\ud574\uc11c \ud655\uc778 \ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/span><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

\uc77c\ub2e8 \uc624\ub77c\ud074\uc740 \uc720\uc800\ub97c \uc0dd\uc131\ud558\uba74\uc11c \ub514\ud3f4\ud2b8\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4.<\/span><\/p>\n<\/span>

\ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uac8c \ub418\uba74 \uadf8 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \ub4e4\uc5b4 \uac00\uac8c\ub418\uace0 \uadf8\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub294 <\/span><\/p>\n<\/span>

\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131\ub54c \uc124\uc815\ud558\ub294 \uacbd\ub85c\uc5d0 \uc704\uce58\ud558\uac8c\ub418\ub294 \uac81\ub2c8\ub2e4.<\/span><\/p>\n<\/span>

 <\/span><\/p>\n<\/span>

select * from all_tables(\uad8c\ud55c\uc804\uccb4) <\/span>
\uc5d0\uc11c \ud14c\uc774\ube14\uc758 \uc815\ubcf4\ub97c \ubcfc\uc218 \uc788\uc2b5\ub2c8\ub2e4 <\/span>
user_tables \/ dba_tables \ub3c4 \uc788\ub294\ub370 <\/span>
\uc0ac\uc6a9\uc790 db\uc804\uccb4 <\/span><\/p>\n<\/span>

\uc774 \ud14c\uc774\ube14\uc5d0 \uc815\ubcf4\ub97c \ubcf4\uace0 \uc54c\uc544\uc11c \uc800\uc7a5\ud574\uc90d\ub2c8\ub2e4.<\/span><\/p><\/span>\n <\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\uc6d0\uae00 : http:\/\/www.zetswing.com\/bbs\/board.php?bo_table=ORACLE_TIP&wr_id=22 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4(TableSpace) \uc815\uc758   \ud14c\uc774\ube14\uc774 \uc800\uc7a5\ub418\ub294 \uacf5\uac04\uc785\ub2c8\ub2e4. \uc624\ub77c\ud074 \uc5d0\uc11c\ub294 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub77c\uace0 \ud574\uc11c \ud14c\uc774\ube14\uc774 \uc800\uc7a5\ub420 \uacf5\uac04\uc744 \uba3c\uc800 \ub9cc\ub4e4\uace0 \ub098\uc11c \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. \uac01\uac01\uc758 \ud14c\uc774\ube14\uc744 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ubcc4\ub85c \ub098\ub204\uc5b4\uc11c \uad00\ub9ac\uc640 \ud37c\ud3ec\uba3c\uc2a4\uc758 \ud5a5\uc0c1\uc744 \uac00\uc9c0\uace0 \uc624\ub294\uac83\uc785\ub2c8\ub2e4.   \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\uba74 \uc815\uc758\ub41c \uc6a9\ub7c9\ub9cc\ud07c \ubbf8\ub9ac \ud655\ubcf4\ud55c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 \uc0dd\uc131\ub418\uc5b4 \uc9c0\uace0 \uc0dd\uc131\ub418\uc5b4\uc9c4 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud0c0\uac00 \uc800\uc7a5\ub429\ub2c8\ub2e4.   \uc608\ub97c \ub4e4\uba74 \ub9ce\uc740 \ub370\uc774\ud130\uac00 \uc313\uc77c \uac8c\uc2dc\ud310 \ud14c\uc774\ube14\uc740 \uae30\ubcf8\uc6a9\ub7c9 100\uba54\uac00 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-409","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=409"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/409\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}