advanced code snippet search

Posted By

mifly on 02/22/10


Tagged

Oracle


Versions (?)

移表和索引的表空间

 / Published in: SQL
 
Expand | Embed | Plain Text 
  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.