rebuild.sql
来自「本人在工程上收集的比较常用的oracle sql语句 有问题请发email:l」· SQL 代码 · 共 649 行 · 第 1/4 页
SQL
649 行
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.STAT_CITY_IDX |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.STAT_CITY_IDX
REBUILD
TABLESPACE USERS
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003078 |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003078
REBUILD
TABLESPACE USERS
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003083 |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003083
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003082 |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003082
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003081 |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003081
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.CONDITION_HLRID_IDX |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.CONDITION_HLRID_IDX
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.CONDITION_VLRID_IDX |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.CONDITION_VLRID_IDX
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.CONDITION_ROAMTYPE_IDX |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.CONDITION_ROAMTYPE_IDX
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.CONDITION_USERID_IDX |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.CONDITION_USERID_IDX
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003080 |
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?