Posted By

mifly on 02/22/10


Tagged

Oracle


Versions (?)

移表和索引的表空间


 / Published in: SQL
 

  1. ALTER TABLE table_name move tablespace ts_name;
  2. ALTER INDEX index_name rebuild tablespace ts_name;
  3.  
  4. SELECT 'alter index '||index_name||' rebuild tablespace UAINDEX_04;'--, t.table_name,tablespace_name
  5. FROM USER_INDEXES T WHERE t.table_owner='test';

Report this snippet  

You need to login to post a comment.