DBA FUS‎ > ‎

Move indexes from data tablespace to index tablespace

posted Sep 13, 2010, 7:07 AM by Sachchida Ojha
SELECT 'ALTER INDEX '||owner||'.'||index_name|| ' REBUILD TABLESPACE <index_tbs_name>; ' from dba_indexes where owner in ('owner_name') and tablespace_name like '%DAT%';

Comments