oracle 自动收缩表空间,Oracle收缩表空间

最新推荐文章于 2024-08-27 08:30:00 发布

荔枝APP

最新推荐文章于 2024-08-27 08:30:00 发布

阅读量278

点赞数

文章标签： oracle 自动收缩表空间

column SQLTEXT format a80

select count(*) from dba_segments where tablespace_name = ‘USERS‘ and segment_type=‘TABLE‘;

select ‘alter table ‘ || owner || ‘.‘ || segment_name || ‘ move tablespace dbs_temp;‘ sqltext from dba_segments where tablespace_name = ‘USERS‘ and segment_type=‘TABLE‘;

select count(*) from dba_segments where tablespace_name = ‘USERS‘ and segment_type=‘INDEX‘;

select ‘alter index ‘ || owner || ‘.‘ || segment_name || ‘ rebuild tablespace dbs_temp;‘ sqltext from dba_segments where tablespace_name = ‘USERS‘ and segment_type=‘INDEX‘;

select count(*) from from dba_lobs where tablespace_name = ‘USERS‘;

select ‘alter table ‘ || owner || ‘.‘ || table_name || ‘ move lob(‘ || column_name || ‘) store as(tablespace dbs_temp);‘ sqltext from dba_lobs where tablespace_name = ‘USERS‘;

原文：http://www.cnblogs.com/ilifeilong/p/7538397.html