--   
--   Script generated at:	09-JAN-2008   20:49
CREATE  SMALLFILE  TABLESPACE "ALRM_ALARM_01_TS_REORG0"
  DATAFILE '/u106/oradata/alrm/ALRM_ALARM_01_TS_reorg0.DBF' SIZE 800M REUSE
  LOGGING  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO 
ALTER SESSION SET sort_area_size = 49999872 sort_area_retained_size = 49999872 
ALTER TABLE "ORACLE"."ALARM" MOVE SUBPARTITION "SYS_SUBP109" TABLESPACE "ALRM_ALARM_01_TS_REORG0" 
ALTER TABLE "ORACLE"."ALARM" MOVE SUBPARTITION "SYS_SUBP119" TABLESPACE "ALRM_ALARM_01_TS_REORG0"  
[Edit MC: remove bunch of alter table and alter index]
ALTER INDEX "ORACLE"."ALARM_TICKET_ID_IDX" REBUILD SUBPARTITION "SYS_SUBP97" TABLESPACE "ALRM_ALARM_IDX_03_TS" 
ALTER INDEX "ORACLE"."ALARM_TICKET_ID_IDX" REBUILD SUBPARTITION "SYS_SUBP99" TABLESPACE "ALRM_ALARM_IDX_04_TS" 
BEGIN DBMS_STATS.GATHER_TABLE_STATS('"ORACLE"', '"ALARM"', estimate_percent=>NULL); END;
BEGIN DBMS_STATS.GATHER_TABLE_STATS('"ORACLE"', '"ALARM"', estimate_percent=>NULL); END;
{Edit MC: remove a bunch of dbms_stats....]
BEGIN DBMS_STATS.GATHER_INDEX_STATS('"ORACLE"', '"ALARM_TICKET_ID_IDX"', estimate_percent=>NULL); END;
BEGIN DBMS_STATS.GATHER_INDEX_STATS('"ORACLE"', '"ALARM_TICKET_ID_IDX"', estimate_percent=>NULL); END;
mgmt$reorg_dropTbsp('"ALRM_ALARM_01_TS"')
ALTER TABLESPACE "ALRM_ALARM_01_TS_REORG0" RENAME TO "ALRM_ALARM_01_TS"