| ormal style="LINE-HEIGHT: 12pt; tab-stops: 0cm 36.0pt 72.0pt 108.0pt 144.0pt 180.0pt 216.0pt; mso-layout-grid-align: none"> WHERE OBJECT_TYPE='TABLE'
然后?行analyze.sql文件即可
最后,??TABLESPACE碎片?M行清理.
SELECT TABLESPACE_NAME, PERCENT_BLOCKS_COALESCED
FROM DBA_FREE_SPACE_COALESCED
去看那一??TABLESPACE????的值不是100的就?行如下命令:
ALTER TABLESPACE TABLESPACE_NAME COALESCE
注意:如果TABLESPACE的值??100就?]有必要作此命令.
9. 移??TABLE INDEX 到另一??TABLESPACE
1> SPOOL C:MV_INDEX.SQL
2> SELECT ‘ALTER INDEX ?
| 