spo move_table.sql
select 'alter table '||table_name||' move tablespace TABLESPACE_YOU_WANT_YOUR_TALBE_MOVE_TO ;' from user_tables;
spo off
spo rebuild_index.sql
select 'alter index '||index_name||' rebuild tablespace TABLESPACE_YOU_WANT_YOUR_INDEX_MOVE_TO ;' from user_indexes;
@move_table.sql
@rebuild_index.sql
阅读(753) | 评论(0) | 转发(0) |
