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
|
|
/
|
|
|