/*給創建bitmap index分配的內存空間參數，以加速建索引*/
show parameter create_bit;
/*改變索引的存儲參數*/
alter index index_name pctfree 30 storage(initial 200k next 200k);
/*給索引手工分配一個分區*/
alter index index_name allocate extent (size 200k datafile '$ORACLE/oradata/..');
/*釋放索引中沒用的空間*/
alter index index_name deallocate unused;
/*索引重建*/
alter index index_name rebuild tablespace tablespace_name;
/*普通索引和反轉索引的互換*/
alter index index_name rebuild tablespace tablespace_name reverse;
/*重建索引時，不鎖表*/
alter index index_name rebuild online;
/*給索引整理碎片*/
alter index index_name COALESCE;
/*分析索引,事實上是更新統計的過程*/
analyze index index_name validate structure;
desc index_state;
drop index index_name;
alter index index_name monitoring usage;-----監視索引是否被用到
alter index index_name nomonitoring usage;----取消監視
/*有關索引信息的視圖*/
select * from dba_indexes/dba_ind_columns/dbs_ind_eXPressions/v$object_usage;
########## 數據完整性的治理(Maintaining data integrity) ##########
alter table table_name drop constraint constraint_name;----drop 約束
alter table table_name add constraint constraint_name primary key(column_name1,column_name2);-----創建主鍵
alter table table_name add constraint constraint_name unique(column_name1,column_name2);---創建唯一約束
/*創建外鍵約束*/
alter table table_name add constraint constraint_name foreign key(column_name1) references table_name(column_name1);
/*不效驗老數據，只約束新的數據[enable/disable：約束/不約束新數據;novalidate/validate:不對/對老數據進行驗證]*/
alter table table_name add constraint constraint_name check(column_name like 'B%') enable/disable novalidate/validate;
/*修改約束條件，延時驗證，commit時驗證*/
alter table table_name modify constraint constraint_name initially deferred;
/*修改約束條件，立即驗證*/
alter table table_name modify constraint constraint_name initially immediate;
alter session set constraints=deferred/immediate;
/*drop一個有外鍵的主鍵表,帶cascade constraints參數級聯刪除*/
drop table table_name cascade constraints;
/*當truncate外鍵表時，先將外鍵設為無效，再truncate;*/
truncate table table_name;
/*設約束條件無效*/
alter table table_name disable constraint constraint_name;
alter table table_name enable novalidate constraint constraint_name;
簡潔實用，謝謝http://wfly2004.blog.163.com/blog/static/11764272010629114155174/
http://hi.baidu.com/zhangcheng1/blog/item/54deb0cc9ab69d1701e9281e.html