schema的常用脚本:moveall.sql
添加时间: 2008-4-26 1:45:18 作者: Oracle指导 阅读次数:12 来源: http://www.d9soft.com
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
@move_build
上一篇文章: RFID技术与中国自主产品对接 下一篇文章: 弥补Oracle数据库访问限制绕过的漏洞
相关软件: