求助:DCNMCONS数据库空间太高无法减少

biazai2002

原帖由 funnyok 于 2008-4-1 20:07 发表
if you customer allow delete all the history data, truncate is the best choice.
but if you cannot lost data, you should
export tables
delete data
alter table move
alter index rebuild

btw, I recomment you move table and rebuild index twice to avoid the fragmentation of extent space.

Could you tell me how to use the command "alter index rebuild", such as, how to get the index of tbl_Event &tbl_HisAlm?

Thanks a lot !

kdkd

select index_name,table_name from dba_indexes where table_name in ('TBL_EVENT','TBL_HISALM');

alter table <table_name> move tablespace <tablespace_name> [storage clause];
alter index <index_name> rebuild tablespace <tablespace_name> [storage clause];

[ 本帖最后由 kdkd 于 2008-4-3 22:32 编辑 ]

biazai2002

多谢各位朋友!
问题解决了,通过
alater table move和 alter index rebuild !
虽然对oracle数据库几乎没什么了解,
但通过这个小问题在这里学到了些东西并解决掉,还得感谢各位朋友的支持!