rebuild.sql
来自「本人在工程上收集的比较常用的oracle sql语句 有问题请发email:l」· SQL 代码 · 共 649 行 · 第 1/4 页
SQL
649 行
SET ECHO ON;
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003089 |
REM | BYTES : 4194304 |
REM | EXTENTS : 4 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003089
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 3604480
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.NO_IDX |
REM | BYTES : 3145728 |
REM | EXTENTS : 3 |
REM +-----------------------------------------------+
ALTER INDEX DYT.NO_IDX
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 2424832
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003090 |
REM | BYTES : 262144 |
REM | EXTENTS : 4 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003090
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003099 |
REM | BYTES : 131072 |
REM | EXTENTS : 2 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003099
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003097 |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003097
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003100 |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003100
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003094 |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003094
REBUILD
TABLESPACE SYSTEM
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003096 |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003096
REBUILD
TABLESPACE USERS
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.HISTORY_IDX |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.HISTORY_IDX
REBUILD
TABLESPACE USERS
STORAGE (
INITIAL 65536
NEXT
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE
);
REM +-----------------------------------------------+
REM | INDEX NAME : DYT.SYS_C003076 |
REM | BYTES : 65536 |
REM | EXTENTS : 1 |
REM +-----------------------------------------------+
ALTER INDEX DYT.SYS_C003076
REBUILD
TABLESPACE USERS
STORAGE (
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?