set term off verify off head off feedback off echo off
spool mvddl.sql
select 'alter '||segment_type||' '||segment_name||''||decode(segment_type,'TABLE',' MOVE ','INDEX',' REBUILD ')||'tablespace ts;' from user_segments where segment_type='INDEX' or segment_type='TABLE';
-------------------------------------------------------------------------
alter TABLE LOB1 MOVE tablespace ts;
alter INDEX INX_LINE REBUILD tablespace ts;
spool off
@mvddl
SQL> select 'alter '||segment_type||' '||segment_name||''||decode(segment_type,'TABLE',' MOVE ','INDEX',' REBUILD ')||'tablespace ts;' from user_segments;
'ALTER'||SEGMENT_TYPE||''||SEGMENT_NAME||''||DECODE(SEGMENT_TYPE,'TABLE','MOVE','INDEX','REBUILD')||'TABLESPACETS;'
---------------------------------------------------------------------------------------------------------------------------------
alter INDEX INX_LINE REBUILD tablespace ts;
alter LOBINDEX <span style="color:#ff0000;">SYS_IL0000051803C00002$$</span> tablespace ts;
alter LOBSEGMENT <span style="color:#ff0000;">SYS_LOB0000051803C00002$$</span> tablespace ts;
alter TABLE LOB1 MOVE tablespace ts;
红色为lob字段索引,该类索引不能通过
alter INDEX ...进行重建。