第二章:表空间管理
K[M2]
b0 1.create tablespaces
\7w
\ew.GX z0
&Lz/e8?8m4O,wwh0 sql> create tablespace tablespace_name datafile 'c:\oracle\oradata\file1.dbf' size 100m,51Testing软件测试网K
D"y;]Y%H
51Testing软件测试网-Q/c1aB(Z.V3P sql> 'c:\oracle\oradata\file2.dbf' size 100m minimum extent 550k [logging/nologging]51Testing软件测试网G:fStC6A&A
51Testing软件测试网:]
w7J;m/Cm.B sql> default storage (initial 500k next 500k maxextents 500 pctinccease 0)
p^2b+^%k-JKQ.X.Y0
/~:b @
G8vS0 sql> [online/offline] [permanent/temporary] [extent_management_clause]51Testing软件测试网!T0B}.l/z/e&Z"yE
51Testing软件测试网%[px6Q4I8Z
g0y9` 2.locally managed tablespace
en
{:ne0
51Testing软件测试网p^hL]e2V&k}z sql> create tablespace user_data datafile 'c:\oracle\oradata\user_data01.dbf'
3S;y"V[.D0
51Testing软件测试网T0g'|${PO'Fu5g sql> size 500m extent management local uniform size 10m;
xZQ"O
MrU{H0
_ ycpu%ce,Nwg0 3.temporary tablespace51Testing软件测试网 EP5RTTp\
R'L?4h7WUX|g2I0 sql> create temporary tablespace temp tempfile 'c:\oracle\oradata\temp01.dbf'
+VN`*S
wT/I0
51Testing软件测试网,fK+kV@+]"?OMn'C sql> size 500m extent management local uniform size 10m;
*J-^H&P}:P
S&VO0
51Testing软件测试网c?V}a e2jc 4.change the storage setting
s}$FZ*A0
*k A/K,dY.R_|&C0 sql> alter tablespace app_data minimum extent 2m;51Testing软件测试网h/z*Q5KRh
51Testing软件测试网 Xo6} {)_EC sql> alter tablespace app_data default storage(initial 2m next 2m maxextents 999);51Testing软件测试网B G6n(M:Pv#ib(p
3VV;L(|
l)Bz/Q[+U)m0 5.taking tablespace offline or online
"[t l7r,jeJz*o4u*Y0
.Q1Z-m-Ms9e#^M4D0 sql> alter tablespace app_data offline;
jTR*M#j{
c0
51Testing软件测试网&?"[zZ![A sql> alter tablespace app_data online;51Testing软件测试网*R"lcr!Xh
51Testing软件测试网1x-Qv1J7B:t&o5G%B 6.read_only tablespace
K"v4WT~oi0
51Testing软件测试网3\xE{-Q;SRtG&R sql> alter tablespace app_data read only|write;
!rao-HI}#J0
51Testing软件测试网-Z7U/}S(bqk 7.droping tablespace
I&h$t%tj(Z0
bO,`
z!I
Qt'Ag h0 sql> drop tablespace app_data including contents;51Testing软件测试网%LR Ca]7i E
51Testing软件测试网z z.q$o.F7C'Z H+C 8.enableing automatic extension of data files
,\"~[)O]0i,WIcp%lG0
51Testing软件测试网gS-Q{8G5SW sql> alter tablespace app_data add datafile 'c:\oracle\oradata\app_data01.dbf' size 200m51Testing软件测试网({c!M[b.m;v"W[{%u
IfI |l"U0 sql> autoextend on next 10m maxsize 500m;
Lbs4e,t7WBO!S.`sh+]0
"hh1s2[#yj#e,S+yz0 9.change the size fo data files manually
PTtp\Wv0
51Testing软件测试网,Koeo%`I sql> alter database datafile 'c:\oracle\oradata\app_data.dbf' resize 200m;
x-d ?.S@n%q__0
51Testing软件测试网
F6n.q;m$G 10.Moving data files: alter tablespace51Testing软件测试网;R9DC!\:z|Z
51Testing软件测试网S
E;TVR%mV sql> alter tablespace app_data rename datafile 'c:\oracle\oradata\app_data.dbf'51Testing软件测试网 D&?.y!L
Q}_
A$};?7z7H&g0 sql> to 'c:\oracle\app_data.dbf';51Testing软件测试网GT/`P/R
j;e+|M
,{6r#Z,Z%jR~}0 11.moving data files:alter database
'z|:j1Q|k"`.}S0
51Testing软件测试网3zWXl9YW:r_ sql> alter database rename file 'c:\oracle\oradata\app_data.dbf'
-g s!{C*e0
UJJ~]w'P0 sql> to 'c:\oracle\app_data.dbf';51Testing软件测试网'b5z8V5b{-R$`:Fa