--继续删除列选项 ALTER TABLE tablename( O) C# G4 m+ L8 D' }. c. \
DROP COLUMNS CONTINUE CHECKPOINT 1000;% p, Z; c, D: E1 k4 d. a" m
--把表放到BUFFER_POOL中去
' h0 r7 j6 @5 X# A+ r I0 y' j5 w' }" F ALTER TABLE tablename, l! @4 t) r( r# m ~# J/ D
STORAGE (BUFFER_POOL RECYCLE);3 I0 P2 t) @! R! N
--避免动态分配EXTENT
+ K, c6 t8 \, {5 E ALTER TABLE tablename ALLOCATE EXTENT;: v# }& F/ D- l+ n' ?; k
--把表放到CACHE中去9 ^( [2 Y: c! g5 k
ALTER TABLE tablename ALLOCATE CACHE/NOCACHE;- ]3 T/ {( c; H" a
4、索引打点# n$ V/ T7 r9 a
--建树索引
! T4 \* F/ H: r n# b7 H( I1 m CREATE INDEX indexname ON TABLENAME(COLUMNNAME);( `; u' A) m: G# F% i, E5 P
CREATE INDEX indexname ON TABLENAME(COLUMNNAME) TABLESPACE TABLESPACENAME;. \( w8 i4 D, b0 z+ C, H& b
--从头成立索引& J/ a7 b9 U+ p
ALTER INDEX indexname REBUILD TABLESPACE TABLESPACE;# ?5 p1 [" A: D
--索引分配参数* o- D) I' m# j' W% T( X1 t
ALTER INDEX indexname
+ q2 I/ A8 @7 ^# Q; U# g6 Y STORAGE(NEXT 400K
* M) i- T1 ?0 n. r MAXEXTENTS 100);6 G y' w- S" p& G+ H' [3 A
--释放索引空间2 w% J6 z9 E- g1 C7 _' k9 p8 B
ALTER INDEX indexname
, n a3 b- x0 \: {% @( T/ D# g0 t ALLOCATE EXTENT (SIZE 200K$ `0 l1 C* [4 a, I* h( d
DATAFILE '/DISK6/indx01.dbf');% \- {: z; t0 ?# m. Y; z7 ~3 `
ALTER INDEX indexname1 _# z/ q: L) m8 e
DEALLOCATE UNUSED;
, O1 p; q2 u0 x' ?& b4 U --从头清算索引表空间碎片
. W% B% Q; y9 i2 g- W6 {- o' G! V, P) a" M( v
ALTER INDEX indexname COALESCE; |