forgood的专栏

select 'alter table ' || table_name || ' move tablespace 新的表空间名称;' from dba_tables T where tablespace_name = '原有表空间' AND T.owner = '数据库实例名';   select 'alter index ' || index_name || ' REBUILD TABLE...

SELECT F.TABLESPACE_NAME,       (T.TOTAL_SPACE - F.FREE_SPACE)   "USED (MB)",       F.FREE_SPACE   "FREE (MB)",       T.TOTAL_SPACE   "TOTAL (MB)",       (ROUND((F.FREE_SPACE / T.TOTAL_SPACE) * 100)) ...