移动表及重建索引代码,PLSQL代码库,德仔网

代码语言

代码分类

【PLSQL】移动表及重建索引

作者:dezai / 发布于2012/9/19/ 913

移动表及重建索引

<div>######################################################################
moveall.sql　--move表及rebuild  索引
set echo off

column order_col1 noprint
column order_col2  noprint

set heading off
set verify off
set feedback  off
set echo off

spool  move_build_tpcrm.sql
!date
select decode( segment_type,  'TABLE',
segment_name, table_name ) order_col1,
decode( segment_type,  'TABLE', 1, 2 ) order_col2,
'alter ' || segment_type || ' ' || segment_name  ||
decode( segment_type, 'TABLE', ' move; ', ' rebuild; ' )
from  user_segments,
(select table_name, index_name from user_indexes  )
where segment_type in ( 'TABLE', 'INDEX' )
and segment_name =  index_name (+)
and tablespace_name in
(自己选择的表空间)
order by 1,  2
/
!date
spool off

set heading on
set verify  on
set feedback on
set echo on

REM UNCOMMENT TO AUTO RUN  the generated commands
REM ELSE edit move_build.sql, modify as needed and  run it</div>

试试其它关键字

　移动表及重建索引　

同语言下

可能有用的

dezai贡献的其它代码(1065)