移动表到其他表空间及重建索引

 

 

 select tablespace_name from dba_segments where segment_name='WRH$_ACTIVE_SESSION_HISTORY';

 

 alter table WRH$_ACTIVE_SESSION_HISTORY move partition WRH$_ACTIVE_3280711463_1505  tablespace system;

 

select dbms_metadata.get_ddl('TABLE','AUD$','SYS') from dual;

select owner,index_name,status from dba_indexes where wner='SYS' and table_name='$WRH_ACTIVE_SESSION_HISTORY';

----重建索引：

alter index WRH$_ACTIVE_SESSION_HISTORY_PK rebuild partition WRH$_ACTIVE_3280711463_1505 tablespace SYSAUX;

----查询重建索引：

select partition_name,status,tablespace_name from dba_ind_partitions where   index_name='WRH$_ACTIVE_SESSION_HISTORY_PK'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24145320/viewspace-701549/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24145320/viewspace-701549/