SQL DDLシ夊。ィ鬆伜沺

陦ィ鬆伜沺縺ィ縺ッシ

シ昴ユ繝シ繝悶Ν繧ケ繝壹シ繧ケ
繧ケ繧ュ繝シ繝槭が繝悶ず繧ァ繧ッ繝医d繝繧」繧ケ繧ッ繧ス繝シ繝医↓菴ソ逕ィ縺吶k縺溘a縺ョ荳譎ら噪縺ェ鬆伜沺繧呈シ邏阪☆繧九◆繧√ョ繧ケ繝医Ξ繝シ繧ク鬆伜沺
蝓コ譛ャ縺ッ陦ィ繧定。ィ鬆伜沺縺ォ謇螻槭&縺帙k縺ィ縲√ョ繝シ繧ソ繝輔ぃ繧、繝ォ縺檎音螳壹ョ陦ィ鬆伜沺縺ォ菫晏ュ倥&繧後k縲
(蝣エ蜷医↓繧医▲縺ヲ縺ッ隲也炊逧縺ォ隍謨ー縺ョ陦ィ鬆伜沺縺ォ謇螻槭&縺帙◆繧翫〒縺阪k)
繝サ陦ィ鬆伜沺蜊倅ス阪〒縺ョ繧「繧ッ繧サ繧ケ蛻カ髯
繝サ陦ィ鬆伜沺蜊倅ス阪〒縺ョ繝舌ャ繧ッ繧「繝繝/繝ェ繧ォ繝舌Μ
繝サ陦ィ鬆伜沺蜊倅ス阪〒菫晏ュ倥ョ繧」繧ケ繧ッ繧貞縺代k莠九〒縺ョI/O騾溷コヲ蜷台ク
CREATE TABLESPACE ス 縺ァ菴懈舌@縲∝ョケ驥上r謖螳壹☆繧九ョ縺ァ縲
繝繝シ繧ソ繝吶シ繧ケ縺ョ繝繝シ繧ソ闢遨阪↓莨エ縺シィシ、縺後ヱ繝ウ繧ッ縺吶k莠九ッ辟。縺縲

SYSTEM陦ィ鬆伜沺

繝サ繝繧」繧ッ繧キ繝ァ繝翫Μ
繝サ繧ケ繝医い繝峨励Ο繧キ繝シ繧ク繝」
繝サSYSTEM繝ュ繝シ繝ォ繝舌ャ繧ッ繧サ繧ー繝。繝ウ繝
繝繝シ繧ソ繝吶シ繧ケ菴懈先凾縺ォ閾ェ蜍慕噪縺ォ菴懈舌&繧後k
縺薙ョ鬆伜沺縺ォ繝ヲ繝シ繧カ繧ェ繝悶ず繧ァ繧ッ繝医r菴懈舌@縺ェ縺

繝ヲ繝シ繧カ陦ィ鬆伜沺

繝繝シ繝悶Ν遲峨ョ繧ケ繧ュ繝シ繝槭が繝悶ず繧ァ繧ッ繝医r菴懈
陦ィ縲∫エ「蠑輔鬆蠎上√ン繝・繝シ豈弱↓陦ィ鬆伜沺繧剃ス懈舌☆繧倶コ九rOracle縺ッ謗ィ螂ィ縺励※縺繧

繝ュ繝シ繝ォ繝舌ャ繧ッ陦ィ鬆伜沺

繝医Λ繝ウ繧カ繧ッ繧キ繝ァ繝ウ繝繝シ繧ソ繧剃ク譎ら噪縺ォ菫晄戟縺吶k鬆伜沺

荳譎り。ィ鬆伜沺

DISTINCT蜿・縲;ROUP BY蜿・縲^RDER BY蜿・繧貞性繧SQL螳溯。梧凾縺ォ蛻ゥ逕ィ縺輔l繧矩伜沺

螳夂セゥ譁ケ豕

菴懈

CREATE TABLESPACE (陦ィ鬆伜沺蜷)
縲DATAFILE (繝繝シ繧ソ繝輔ぃ繧、繝ォ蜷.dbf) SIZE 100M;
陦ィ鬆伜沺繧剃ス懈(繧ェ繝励す繝ァ繝ウ)
CREATE TABLESPACE (陦ィ鬆伜沺蜷)
縲DATAFILE (繝繝シ繧ソ繝輔ぃ繧、繝ォ蜷.dbf) SIZE 100M;
縲AUTOEXTEND ON NEXT 500K MAXSIZE 1024M;
閾ェ蜍墓僑蠑オ500K縺ァ譛螟ァ1024M
縲AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
閾ェ蜍墓僑蠑オ500K縺ァ譛螟ァ繧オ繧、繧コ辟。蛻カ髯
縲AUTOEXTEND OFF NEXT 500K MAXSIZE 1024M;
閾ェ蜍墓僑蠑オ辟。縺励〒譛螟ァ1024M
縲BLOCKSIZE 繝悶Ο繝繧ッ繧オ繧、繧コ
隍謨ー縺ョ繝繝シ繧ソ繝輔ぃ繧、繝ォ縺ォ縺セ縺溘′縺」縺溯。ィ鬆伜沺繧剃ス懈
CREATE TABLESPACE (陦ィ鬆伜沺蜷)
縲DATAFILE (繝繝シ繧ソ繝輔ぃ繧、繝ォ蜷1.dbf) SIZE 100M;
縲DATAFILE (繝繝シ繧ソ繝輔ぃ繧、繝ォ蜷2.dbf) SIZE 100M;
縲AUTOEXTEND ON NEXT 500K MAXSIZE 1024M;

諡。蠑オ

ALTER TABLESPACE (陦ィ鬆伜沺蜷)
ADD DATAFILE 'ス/(繝繝シ繧ソ繝輔ぃ繧、繝ォ蜷).dbf' SIZE 100M;
ALTER DATABASE DATAFILE 'ス/(繝繝シ繧ソ繝輔ぃ繧、繝ォ蜷).dbf ';
RESIZE 150M
AUTOEXTEND ON 窶サ閾ェ蜍墓僑蠑オ
NEXT 10M
MAXSIZE UNLIMITED;

蜑企勁

DROP TABLESPACE 陦ィ鬆伜沺蜷;
(陦ィ鬆伜沺縺ォ繧ェ繝悶ず繧ァ繧ッ繝医′縺ゅk蝣エ蜷医ッ繧ィ繝ゥ繝シ)
DROP TABLESPACE 陦ィ鬆伜沺蜷 INCLUDING CONTENTS AND DATAFILES;
(陦ィ鬆伜沺縺ォ繧ェ繝悶ず繧ァ繧ッ繝医′縺ゅk蝣エ蜷医b蜿ッ縲ゅョ繝シ繧ソ繝輔ぃ繧、繝ォ繧ょ酔譎ょ炎髯、)
窶サEM縺ォ縺翫¢繧玖。ィ鬆伜沺蜑企勁譎ゅョ謖吝虚縺ィ蜷後§

遘サ蜍

ALTER TABLESPACE 譌ァ陦ィ鬆伜沺蜷 RENAME TO 譁ー陦ィ鬆伜沺蜷;

陦ィ菴懈先凾縺ョ陦ィ鬆伜沺謖螳

SQL DDLシ壹ユ繝シ繝悶Ν螳夂セゥ縲榊盾辣ァ

Follow me!

谺。縺ョ險倅コ

SQL DDLシ壹励Ο繝輔ぃ繧、繝ォ