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