275 lines
3.3 KiB
MySQL
275 lines
3.3 KiB
MySQL
|
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
||
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
||
|
|
|
||
|
|
--DROP TABLE t_intrablock_chained ;
|
||
|
|
|
||
|
|
CREATE TABLE t_intrablock_chained
|
||
|
|
TABLESPACE tanel_bigfile
|
||
|
|
AS SELECT
|
||
|
|
CAST('x' AS CHAR(100)) padding
|
||
|
|
, 0 col_1
|
||
|
|
, 0 col_2
|
||
|
|
, 0 col_3
|
||
|
|
, 0 col_4
|
||
|
|
, 0 col_5
|
||
|
|
, 0 col_6
|
||
|
|
, 0 col_7
|
||
|
|
, 0 col_8
|
||
|
|
, 0 col_9
|
||
|
|
, 0 col_10
|
||
|
|
, 0 col_11
|
||
|
|
, 0 col_12
|
||
|
|
, 0 col_13
|
||
|
|
, 0 col_14
|
||
|
|
, 0 col_15
|
||
|
|
, 0 col_16
|
||
|
|
, 0 col_17
|
||
|
|
, 0 col_18
|
||
|
|
, 0 col_19
|
||
|
|
, 0 col_20
|
||
|
|
, 0 col_21
|
||
|
|
, 0 col_22
|
||
|
|
, 0 col_23
|
||
|
|
, 0 col_24
|
||
|
|
, 0 col_25
|
||
|
|
, 0 col_26
|
||
|
|
, 0 col_27
|
||
|
|
, 0 col_28
|
||
|
|
, 0 col_29
|
||
|
|
, 0 col_30
|
||
|
|
, 0 col_31
|
||
|
|
, 0 col_32
|
||
|
|
, 0 col_33
|
||
|
|
, 0 col_34
|
||
|
|
, 0 col_35
|
||
|
|
, 0 col_36
|
||
|
|
, 0 col_37
|
||
|
|
, 0 col_38
|
||
|
|
, 0 col_39
|
||
|
|
, 0 col_40
|
||
|
|
, 0 col_41
|
||
|
|
, 0 col_42
|
||
|
|
, 0 col_43
|
||
|
|
, 0 col_44
|
||
|
|
, 0 col_45
|
||
|
|
, 0 col_46
|
||
|
|
, 0 col_47
|
||
|
|
, 0 col_48
|
||
|
|
, 0 col_49
|
||
|
|
, 0 col_50
|
||
|
|
, 0 col_51
|
||
|
|
, 0 col_52
|
||
|
|
, 0 col_53
|
||
|
|
, 0 col_54
|
||
|
|
, 0 col_55
|
||
|
|
, 0 col_56
|
||
|
|
, 0 col_57
|
||
|
|
, 0 col_58
|
||
|
|
, 0 col_59
|
||
|
|
, 0 col_60
|
||
|
|
, 0 col_61
|
||
|
|
, 0 col_62
|
||
|
|
, 0 col_63
|
||
|
|
, 0 col_64
|
||
|
|
, 0 col_65
|
||
|
|
, 0 col_66
|
||
|
|
, 0 col_67
|
||
|
|
, 0 col_68
|
||
|
|
, 0 col_69
|
||
|
|
, 0 col_70
|
||
|
|
, 0 col_71
|
||
|
|
, 0 col_72
|
||
|
|
, 0 col_73
|
||
|
|
, 0 col_74
|
||
|
|
, 0 col_75
|
||
|
|
, 0 col_76
|
||
|
|
, 0 col_77
|
||
|
|
, 0 col_78
|
||
|
|
, 0 col_79
|
||
|
|
, 0 col_80
|
||
|
|
, 0 col_81
|
||
|
|
, 0 col_82
|
||
|
|
, 0 col_83
|
||
|
|
, 0 col_84
|
||
|
|
, 0 col_85
|
||
|
|
, 0 col_86
|
||
|
|
, 0 col_87
|
||
|
|
, 0 col_88
|
||
|
|
, 0 col_89
|
||
|
|
, 0 col_90
|
||
|
|
, 0 col_91
|
||
|
|
, 0 col_92
|
||
|
|
, 0 col_93
|
||
|
|
, 0 col_94
|
||
|
|
, 0 col_95
|
||
|
|
, 0 col_96
|
||
|
|
, 0 col_97
|
||
|
|
, 0 col_98
|
||
|
|
, 0 col_99
|
||
|
|
, 0 col_100
|
||
|
|
, 0 col_101
|
||
|
|
, 0 col_102
|
||
|
|
, 0 col_103
|
||
|
|
, 0 col_104
|
||
|
|
, 0 col_105
|
||
|
|
, 0 col_106
|
||
|
|
, 0 col_107
|
||
|
|
, 0 col_108
|
||
|
|
, 0 col_109
|
||
|
|
, 0 col_110
|
||
|
|
, 0 col_111
|
||
|
|
, 0 col_112
|
||
|
|
, 0 col_113
|
||
|
|
, 0 col_114
|
||
|
|
, 0 col_115
|
||
|
|
, 0 col_116
|
||
|
|
, 0 col_117
|
||
|
|
, 0 col_118
|
||
|
|
, 0 col_119
|
||
|
|
, 0 col_120
|
||
|
|
, 0 col_121
|
||
|
|
, 0 col_122
|
||
|
|
, 0 col_123
|
||
|
|
, 0 col_124
|
||
|
|
, 0 col_125
|
||
|
|
, 0 col_126
|
||
|
|
, 0 col_127
|
||
|
|
, 0 col_128
|
||
|
|
, 0 col_129
|
||
|
|
, 0 col_130
|
||
|
|
, 0 col_131
|
||
|
|
, 0 col_132
|
||
|
|
, 0 col_133
|
||
|
|
, 0 col_134
|
||
|
|
, 0 col_135
|
||
|
|
, 0 col_136
|
||
|
|
, 0 col_137
|
||
|
|
, 0 col_138
|
||
|
|
, 0 col_139
|
||
|
|
, 0 col_140
|
||
|
|
, 0 col_141
|
||
|
|
, 0 col_142
|
||
|
|
, 0 col_143
|
||
|
|
, 0 col_144
|
||
|
|
, 0 col_145
|
||
|
|
, 0 col_146
|
||
|
|
, 0 col_147
|
||
|
|
, 0 col_148
|
||
|
|
, 0 col_149
|
||
|
|
, 0 col_150
|
||
|
|
, 0 col_151
|
||
|
|
, 0 col_152
|
||
|
|
, 0 col_153
|
||
|
|
, 0 col_154
|
||
|
|
, 0 col_155
|
||
|
|
, 0 col_156
|
||
|
|
, 0 col_157
|
||
|
|
, 0 col_158
|
||
|
|
, 0 col_159
|
||
|
|
, 0 col_160
|
||
|
|
, 0 col_161
|
||
|
|
, 0 col_162
|
||
|
|
, 0 col_163
|
||
|
|
, 0 col_164
|
||
|
|
, 0 col_165
|
||
|
|
, 0 col_166
|
||
|
|
, 0 col_167
|
||
|
|
, 0 col_168
|
||
|
|
, 0 col_169
|
||
|
|
, 0 col_170
|
||
|
|
, 0 col_171
|
||
|
|
, 0 col_172
|
||
|
|
, 0 col_173
|
||
|
|
, 0 col_174
|
||
|
|
, 0 col_175
|
||
|
|
, 0 col_176
|
||
|
|
, 0 col_177
|
||
|
|
, 0 col_178
|
||
|
|
, 0 col_179
|
||
|
|
, 0 col_180
|
||
|
|
, 0 col_181
|
||
|
|
, 0 col_182
|
||
|
|
, 0 col_183
|
||
|
|
, 0 col_184
|
||
|
|
, 0 col_185
|
||
|
|
, 0 col_186
|
||
|
|
, 0 col_187
|
||
|
|
, 0 col_188
|
||
|
|
, 0 col_189
|
||
|
|
, 0 col_190
|
||
|
|
, 0 col_191
|
||
|
|
, 0 col_192
|
||
|
|
, 0 col_193
|
||
|
|
, 0 col_194
|
||
|
|
, 0 col_195
|
||
|
|
, 0 col_196
|
||
|
|
, 0 col_197
|
||
|
|
, 0 col_198
|
||
|
|
, 0 col_199
|
||
|
|
, 0 col_200
|
||
|
|
, 0 col_201
|
||
|
|
, 0 col_202
|
||
|
|
, 0 col_203
|
||
|
|
, 0 col_204
|
||
|
|
, 0 col_205
|
||
|
|
, 0 col_206
|
||
|
|
, 0 col_207
|
||
|
|
, 0 col_208
|
||
|
|
, 0 col_209
|
||
|
|
, 0 col_210
|
||
|
|
, 0 col_211
|
||
|
|
, 0 col_212
|
||
|
|
, 0 col_213
|
||
|
|
, 0 col_214
|
||
|
|
, 0 col_215
|
||
|
|
, 0 col_216
|
||
|
|
, 0 col_217
|
||
|
|
, 0 col_218
|
||
|
|
, 0 col_219
|
||
|
|
, 0 col_220
|
||
|
|
, 0 col_221
|
||
|
|
, 0 col_222
|
||
|
|
, 0 col_223
|
||
|
|
, 0 col_224
|
||
|
|
, 0 col_225
|
||
|
|
, 0 col_226
|
||
|
|
, 0 col_227
|
||
|
|
, 0 col_228
|
||
|
|
, 0 col_229
|
||
|
|
, 0 col_230
|
||
|
|
, 0 col_231
|
||
|
|
, 0 col_232
|
||
|
|
, 0 col_233
|
||
|
|
, 0 col_234
|
||
|
|
, 0 col_235
|
||
|
|
, 0 col_236
|
||
|
|
, 0 col_237
|
||
|
|
, 0 col_238
|
||
|
|
, 0 col_239
|
||
|
|
, 0 col_240
|
||
|
|
, 0 col_241
|
||
|
|
, 0 col_242
|
||
|
|
, 0 col_243
|
||
|
|
, 0 col_244
|
||
|
|
, 0 col_245
|
||
|
|
, 0 col_246
|
||
|
|
, 0 col_247
|
||
|
|
, 0 col_248
|
||
|
|
, 0 col_249
|
||
|
|
, 0 col_250
|
||
|
|
, 0 col_251
|
||
|
|
, 0 col_252
|
||
|
|
, 0 col_253
|
||
|
|
, 0 col_254
|
||
|
|
, 0 col_255
|
||
|
|
, 0 col_256
|
||
|
|
, 0 col_257
|
||
|
|
, 0 col_258
|
||
|
|
, 0 col_259
|
||
|
|
, 0 col_260
|
||
|
|
FROM
|
||
|
|
DUAL
|
||
|
|
CONNECT BY LEVEL <= 1000000
|
||
|
|
/
|
||
|
|
|