| 1 |
# |
| 2 |
# InnoDB supports CREATE/ALTER/DROP UNDO TABLESPACE |
| 3 |
# Show that up to 125 explicit undo tablespaces can be created. |
| 4 |
# |
| 5 |
CREATE UNDO TABLESPACE undo_3 ADD DATAFILE 'undo_3.ibu'; |
| 6 |
CREATE UNDO TABLESPACE undo_4 ADD DATAFILE 'undo_4.ibu'; |
| 7 |
CREATE UNDO TABLESPACE undo_5 ADD DATAFILE 'undo_5.ibu'; |
| 8 |
CREATE UNDO TABLESPACE undo_6 ADD DATAFILE 'undo_6.ibu'; |
| 9 |
CREATE UNDO TABLESPACE undo_7 ADD DATAFILE 'undo_7.ibu'; |
| 10 |
CREATE UNDO TABLESPACE undo_8 ADD DATAFILE 'undo_8.ibu'; |
| 11 |
CREATE UNDO TABLESPACE undo_9 ADD DATAFILE 'undo_9.ibu'; |
| 12 |
CREATE UNDO TABLESPACE undo_10 ADD DATAFILE 'undo_10.ibu'; |
| 13 |
CREATE UNDO TABLESPACE undo_11 ADD DATAFILE 'undo_11.ibu'; |
| 14 |
CREATE UNDO TABLESPACE undo_12 ADD DATAFILE 'undo_12.ibu'; |
| 15 |
CREATE UNDO TABLESPACE undo_13 ADD DATAFILE 'undo_13.ibu'; |
| 16 |
CREATE UNDO TABLESPACE undo_14 ADD DATAFILE 'undo_14.ibu'; |
| 17 |
CREATE UNDO TABLESPACE undo_15 ADD DATAFILE 'undo_15.ibu'; |
| 18 |
CREATE UNDO TABLESPACE undo_16 ADD DATAFILE 'undo_16.ibu'; |
| 19 |
CREATE UNDO TABLESPACE undo_17 ADD DATAFILE 'undo_17.ibu'; |
| 20 |
CREATE UNDO TABLESPACE undo_18 ADD DATAFILE 'undo_18.ibu'; |
| 21 |
CREATE UNDO TABLESPACE undo_19 ADD DATAFILE 'undo_19.ibu'; |
| 22 |
CREATE UNDO TABLESPACE undo_20 ADD DATAFILE 'undo_20.ibu'; |
| 23 |
CREATE UNDO TABLESPACE undo_21 ADD DATAFILE 'undo_21.ibu'; |
| 24 |
CREATE UNDO TABLESPACE undo_22 ADD DATAFILE 'undo_22.ibu'; |
| 25 |
CREATE UNDO TABLESPACE undo_23 ADD DATAFILE 'undo_23.ibu'; |
| 26 |
CREATE UNDO TABLESPACE undo_24 ADD DATAFILE 'undo_24.ibu'; |
| 27 |
CREATE UNDO TABLESPACE undo_25 ADD DATAFILE 'undo_25.ibu'; |
| 28 |
CREATE UNDO TABLESPACE undo_26 ADD DATAFILE 'undo_26.ibu'; |
| 29 |
CREATE UNDO TABLESPACE undo_27 ADD DATAFILE 'undo_27.ibu'; |
| 30 |
CREATE UNDO TABLESPACE undo_28 ADD DATAFILE 'undo_28.ibu'; |
| 31 |
CREATE UNDO TABLESPACE undo_29 ADD DATAFILE 'undo_29.ibu'; |
| 32 |
CREATE UNDO TABLESPACE undo_30 ADD DATAFILE 'undo_30.ibu'; |
| 33 |
CREATE UNDO TABLESPACE undo_31 ADD DATAFILE 'undo_31.ibu'; |
| 34 |
CREATE UNDO TABLESPACE undo_32 ADD DATAFILE 'undo_32.ibu'; |
| 35 |
CREATE UNDO TABLESPACE undo_33 ADD DATAFILE 'undo_33.ibu'; |
| 36 |
CREATE UNDO TABLESPACE undo_34 ADD DATAFILE 'undo_34.ibu'; |
| 37 |
CREATE UNDO TABLESPACE undo_35 ADD DATAFILE 'undo_35.ibu'; |
| 38 |
CREATE UNDO TABLESPACE undo_36 ADD DATAFILE 'undo_36.ibu'; |
| 39 |
CREATE UNDO TABLESPACE undo_37 ADD DATAFILE 'undo_37.ibu'; |
| 40 |
CREATE UNDO TABLESPACE undo_38 ADD DATAFILE 'undo_38.ibu'; |
| 41 |
CREATE UNDO TABLESPACE undo_39 ADD DATAFILE 'undo_39.ibu'; |
| 42 |
CREATE UNDO TABLESPACE undo_40 ADD DATAFILE 'undo_40.ibu'; |
| 43 |
CREATE UNDO TABLESPACE undo_41 ADD DATAFILE 'undo_41.ibu'; |
| 44 |
CREATE UNDO TABLESPACE undo_42 ADD DATAFILE 'undo_42.ibu'; |
| 45 |
CREATE UNDO TABLESPACE undo_43 ADD DATAFILE 'undo_43.ibu'; |
| 46 |
CREATE UNDO TABLESPACE undo_44 ADD DATAFILE 'undo_44.ibu'; |
| 47 |
CREATE UNDO TABLESPACE undo_45 ADD DATAFILE 'undo_45.ibu'; |
| 48 |
CREATE UNDO TABLESPACE undo_46 ADD DATAFILE 'undo_46.ibu'; |
| 49 |
CREATE UNDO TABLESPACE undo_47 ADD DATAFILE 'undo_47.ibu'; |
| 50 |
CREATE UNDO TABLESPACE undo_48 ADD DATAFILE 'undo_48.ibu'; |
| 51 |
CREATE UNDO TABLESPACE undo_49 ADD DATAFILE 'undo_49.ibu'; |
| 52 |
CREATE UNDO TABLESPACE undo_50 ADD DATAFILE 'undo_50.ibu'; |
| 53 |
CREATE UNDO TABLESPACE undo_51 ADD DATAFILE 'undo_51.ibu'; |
| 54 |
CREATE UNDO TABLESPACE undo_52 ADD DATAFILE 'undo_52.ibu'; |
| 55 |
CREATE UNDO TABLESPACE undo_53 ADD DATAFILE 'undo_53.ibu'; |
| 56 |
CREATE UNDO TABLESPACE undo_54 ADD DATAFILE 'undo_54.ibu'; |
| 57 |
CREATE UNDO TABLESPACE undo_55 ADD DATAFILE 'undo_55.ibu'; |
| 58 |
CREATE UNDO TABLESPACE undo_56 ADD DATAFILE 'undo_56.ibu'; |
| 59 |
CREATE UNDO TABLESPACE undo_57 ADD DATAFILE 'undo_57.ibu'; |
| 60 |
CREATE UNDO TABLESPACE undo_58 ADD DATAFILE 'undo_58.ibu'; |
| 61 |
CREATE UNDO TABLESPACE undo_59 ADD DATAFILE 'undo_59.ibu'; |
| 62 |
CREATE UNDO TABLESPACE undo_60 ADD DATAFILE 'undo_60.ibu'; |
| 63 |
CREATE UNDO TABLESPACE undo_61 ADD DATAFILE 'undo_61.ibu'; |
| 64 |
CREATE UNDO TABLESPACE undo_62 ADD DATAFILE 'undo_62.ibu'; |
| 65 |
CREATE UNDO TABLESPACE undo_63 ADD DATAFILE 'undo_63.ibu'; |
| 66 |
CREATE UNDO TABLESPACE undo_64 ADD DATAFILE 'undo_64.ibu'; |
| 67 |
CREATE UNDO TABLESPACE undo_65 ADD DATAFILE 'undo_65.ibu'; |
| 68 |
CREATE UNDO TABLESPACE undo_66 ADD DATAFILE 'undo_66.ibu'; |
| 69 |
CREATE UNDO TABLESPACE undo_67 ADD DATAFILE 'undo_67.ibu'; |
| 70 |
CREATE UNDO TABLESPACE undo_68 ADD DATAFILE 'undo_68.ibu'; |
| 71 |
CREATE UNDO TABLESPACE undo_69 ADD DATAFILE 'undo_69.ibu'; |
| 72 |
CREATE UNDO TABLESPACE undo_70 ADD DATAFILE 'undo_70.ibu'; |
| 73 |
CREATE UNDO TABLESPACE undo_71 ADD DATAFILE 'undo_71.ibu'; |
| 74 |
CREATE UNDO TABLESPACE undo_72 ADD DATAFILE 'undo_72.ibu'; |
| 75 |
CREATE UNDO TABLESPACE undo_73 ADD DATAFILE 'undo_73.ibu'; |
| 76 |
CREATE UNDO TABLESPACE undo_74 ADD DATAFILE 'undo_74.ibu'; |
| 77 |
CREATE UNDO TABLESPACE undo_75 ADD DATAFILE 'undo_75.ibu'; |
| 78 |
CREATE UNDO TABLESPACE undo_76 ADD DATAFILE 'undo_76.ibu'; |
| 79 |
CREATE UNDO TABLESPACE undo_77 ADD DATAFILE 'undo_77.ibu'; |
| 80 |
CREATE UNDO TABLESPACE undo_78 ADD DATAFILE 'undo_78.ibu'; |
| 81 |
CREATE UNDO TABLESPACE undo_79 ADD DATAFILE 'undo_79.ibu'; |
| 82 |
CREATE UNDO TABLESPACE undo_80 ADD DATAFILE 'undo_80.ibu'; |
| 83 |
CREATE UNDO TABLESPACE undo_81 ADD DATAFILE 'undo_81.ibu'; |
| 84 |
CREATE UNDO TABLESPACE undo_82 ADD DATAFILE 'undo_82.ibu'; |
| 85 |
CREATE UNDO TABLESPACE undo_83 ADD DATAFILE 'undo_83.ibu'; |
| 86 |
CREATE UNDO TABLESPACE undo_84 ADD DATAFILE 'undo_84.ibu'; |
| 87 |
CREATE UNDO TABLESPACE undo_85 ADD DATAFILE 'undo_85.ibu'; |
| 88 |
CREATE UNDO TABLESPACE undo_86 ADD DATAFILE 'undo_86.ibu'; |
| 89 |
CREATE UNDO TABLESPACE undo_87 ADD DATAFILE 'undo_87.ibu'; |
| 90 |
CREATE UNDO TABLESPACE undo_88 ADD DATAFILE 'undo_88.ibu'; |
| 91 |
CREATE UNDO TABLESPACE undo_89 ADD DATAFILE 'undo_89.ibu'; |
| 92 |
CREATE UNDO TABLESPACE undo_90 ADD DATAFILE 'undo_90.ibu'; |
| 93 |
CREATE UNDO TABLESPACE undo_91 ADD DATAFILE 'undo_91.ibu'; |
| 94 |
CREATE UNDO TABLESPACE undo_92 ADD DATAFILE 'undo_92.ibu'; |
| 95 |
CREATE UNDO TABLESPACE undo_93 ADD DATAFILE 'undo_93.ibu'; |
| 96 |
CREATE UNDO TABLESPACE undo_94 ADD DATAFILE 'undo_94.ibu'; |
| 97 |
CREATE UNDO TABLESPACE undo_95 ADD DATAFILE 'undo_95.ibu'; |
| 98 |
CREATE UNDO TABLESPACE undo_96 ADD DATAFILE 'undo_96.ibu'; |
| 99 |
CREATE UNDO TABLESPACE undo_97 ADD DATAFILE 'undo_97.ibu'; |
| 100 |
CREATE UNDO TABLESPACE undo_98 ADD DATAFILE 'undo_98.ibu'; |
| 101 |
CREATE UNDO TABLESPACE undo_99 ADD DATAFILE 'undo_99.ibu'; |
| 102 |
CREATE UNDO TABLESPACE undo_100 ADD DATAFILE 'undo_100.ibu'; |
| 103 |
CREATE UNDO TABLESPACE undo_101 ADD DATAFILE 'undo_101.ibu'; |
| 104 |
CREATE UNDO TABLESPACE undo_102 ADD DATAFILE 'undo_102.ibu'; |
| 105 |
CREATE UNDO TABLESPACE undo_103 ADD DATAFILE 'undo_103.ibu'; |
| 106 |
CREATE UNDO TABLESPACE undo_104 ADD DATAFILE 'undo_104.ibu'; |
| 107 |
CREATE UNDO TABLESPACE undo_105 ADD DATAFILE 'undo_105.ibu'; |
| 108 |
CREATE UNDO TABLESPACE undo_106 ADD DATAFILE 'undo_106.ibu'; |
| 109 |
CREATE UNDO TABLESPACE undo_107 ADD DATAFILE 'undo_107.ibu'; |
| 110 |
CREATE UNDO TABLESPACE undo_108 ADD DATAFILE 'undo_108.ibu'; |
| 111 |
CREATE UNDO TABLESPACE undo_109 ADD DATAFILE 'undo_109.ibu'; |
| 112 |
CREATE UNDO TABLESPACE undo_110 ADD DATAFILE 'undo_110.ibu'; |
| 113 |
CREATE UNDO TABLESPACE undo_111 ADD DATAFILE 'undo_111.ibu'; |
| 114 |
CREATE UNDO TABLESPACE undo_112 ADD DATAFILE 'undo_112.ibu'; |
| 115 |
CREATE UNDO TABLESPACE undo_113 ADD DATAFILE 'undo_113.ibu'; |
| 116 |
CREATE UNDO TABLESPACE undo_114 ADD DATAFILE 'undo_114.ibu'; |
| 117 |
CREATE UNDO TABLESPACE undo_115 ADD DATAFILE 'undo_115.ibu'; |
| 118 |
CREATE UNDO TABLESPACE undo_116 ADD DATAFILE 'undo_116.ibu'; |
| 119 |
CREATE UNDO TABLESPACE undo_117 ADD DATAFILE 'undo_117.ibu'; |
| 120 |
CREATE UNDO TABLESPACE undo_118 ADD DATAFILE 'undo_118.ibu'; |
| 121 |
CREATE UNDO TABLESPACE undo_119 ADD DATAFILE 'undo_119.ibu'; |
| 122 |
CREATE UNDO TABLESPACE undo_120 ADD DATAFILE 'undo_120.ibu'; |
| 123 |
CREATE UNDO TABLESPACE undo_121 ADD DATAFILE 'undo_121.ibu'; |
| 124 |
CREATE UNDO TABLESPACE undo_122 ADD DATAFILE 'undo_122.ibu'; |
| 125 |
CREATE UNDO TABLESPACE undo_123 ADD DATAFILE 'undo_123.ibu'; |
| 126 |
CREATE UNDO TABLESPACE undo_124 ADD DATAFILE 'undo_124.ibu'; |
| 127 |
CREATE UNDO TABLESPACE undo_125 ADD DATAFILE 'undo_125.ibu'; |
| 128 |
CREATE UNDO TABLESPACE undo_126 ADD DATAFILE 'undo_126.ibu'; |
| 129 |
CREATE UNDO TABLESPACE undo_127 ADD DATAFILE 'undo_127.ibu'; |
| 130 |
CREATE UNDO TABLESPACE undo_128 ADD DATAFILE 'undo_128.ibu'; |
| 131 |
ERROR HY000: Failed to create UNDO TABLESPACE undo_128 |
| 132 |
SHOW WARNINGS; |
| 133 |
Level Code Message |
| 134 |
Error 1528 Failed to create UNDO TABLESPACE undo_128 |
| 135 |
Error 1813 Tablespace 'undo_128' exists. |
| 136 |
ALTER UNDO TABLESPACE undo_3 SET INACTIVE; |
| 137 |
ALTER UNDO TABLESPACE undo_4 SET INACTIVE; |
| 138 |
ALTER UNDO TABLESPACE undo_5 SET INACTIVE; |
| 139 |
ALTER UNDO TABLESPACE undo_6 SET INACTIVE; |
| 140 |
ALTER UNDO TABLESPACE undo_7 SET INACTIVE; |
| 141 |
ALTER UNDO TABLESPACE undo_8 SET INACTIVE; |
| 142 |
ALTER UNDO TABLESPACE undo_9 SET INACTIVE; |
| 143 |
ALTER UNDO TABLESPACE undo_10 SET INACTIVE; |
| 144 |
ALTER UNDO TABLESPACE undo_11 SET INACTIVE; |
| 145 |
ALTER UNDO TABLESPACE undo_12 SET INACTIVE; |
| 146 |
ALTER UNDO TABLESPACE undo_13 SET INACTIVE; |
| 147 |
ALTER UNDO TABLESPACE undo_14 SET INACTIVE; |
| 148 |
ALTER UNDO TABLESPACE undo_15 SET INACTIVE; |
| 149 |
ALTER UNDO TABLESPACE undo_16 SET INACTIVE; |
| 150 |
ALTER UNDO TABLESPACE undo_17 SET INACTIVE; |
| 151 |
ALTER UNDO TABLESPACE undo_18 SET INACTIVE; |
| 152 |
ALTER UNDO TABLESPACE undo_19 SET INACTIVE; |
| 153 |
ALTER UNDO TABLESPACE undo_20 SET INACTIVE; |
| 154 |
ALTER UNDO TABLESPACE undo_21 SET INACTIVE; |
| 155 |
ALTER UNDO TABLESPACE undo_22 SET INACTIVE; |
| 156 |
ALTER UNDO TABLESPACE undo_23 SET INACTIVE; |
| 157 |
ALTER UNDO TABLESPACE undo_24 SET INACTIVE; |
| 158 |
ALTER UNDO TABLESPACE undo_25 SET INACTIVE; |
| 159 |
ALTER UNDO TABLESPACE undo_26 SET INACTIVE; |
| 160 |
ALTER UNDO TABLESPACE undo_27 SET INACTIVE; |
| 161 |
ALTER UNDO TABLESPACE undo_28 SET INACTIVE; |
| 162 |
ALTER UNDO TABLESPACE undo_29 SET INACTIVE; |
| 163 |
ALTER UNDO TABLESPACE undo_30 SET INACTIVE; |
| 164 |
ALTER UNDO TABLESPACE undo_31 SET INACTIVE; |
| 165 |
ALTER UNDO TABLESPACE undo_32 SET INACTIVE; |
| 166 |
ALTER UNDO TABLESPACE undo_33 SET INACTIVE; |
| 167 |
ALTER UNDO TABLESPACE undo_34 SET INACTIVE; |
| 168 |
ALTER UNDO TABLESPACE undo_35 SET INACTIVE; |
| 169 |
ALTER UNDO TABLESPACE undo_36 SET INACTIVE; |
| 170 |
ALTER UNDO TABLESPACE undo_37 SET INACTIVE; |
| 171 |
ALTER UNDO TABLESPACE undo_38 SET INACTIVE; |
| 172 |
ALTER UNDO TABLESPACE undo_39 SET INACTIVE; |
| 173 |
ALTER UNDO TABLESPACE undo_40 SET INACTIVE; |
| 174 |
ALTER UNDO TABLESPACE undo_41 SET INACTIVE; |
| 175 |
ALTER UNDO TABLESPACE undo_42 SET INACTIVE; |
| 176 |
ALTER UNDO TABLESPACE undo_43 SET INACTIVE; |
| 177 |
ALTER UNDO TABLESPACE undo_44 SET INACTIVE; |
| 178 |
ALTER UNDO TABLESPACE undo_45 SET INACTIVE; |
| 179 |
ALTER UNDO TABLESPACE undo_46 SET INACTIVE; |
| 180 |
ALTER UNDO TABLESPACE undo_47 SET INACTIVE; |
| 181 |
ALTER UNDO TABLESPACE undo_48 SET INACTIVE; |
| 182 |
ALTER UNDO TABLESPACE undo_49 SET INACTIVE; |
| 183 |
ALTER UNDO TABLESPACE undo_50 SET INACTIVE; |
| 184 |
ALTER UNDO TABLESPACE undo_51 SET INACTIVE; |
| 185 |
ALTER UNDO TABLESPACE undo_52 SET INACTIVE; |
| 186 |
ALTER UNDO TABLESPACE undo_53 SET INACTIVE; |
| 187 |
ALTER UNDO TABLESPACE undo_54 SET INACTIVE; |
| 188 |
ALTER UNDO TABLESPACE undo_55 SET INACTIVE; |
| 189 |
ALTER UNDO TABLESPACE undo_56 SET INACTIVE; |
| 190 |
ALTER UNDO TABLESPACE undo_57 SET INACTIVE; |
| 191 |
ALTER UNDO TABLESPACE undo_58 SET INACTIVE; |
| 192 |
ALTER UNDO TABLESPACE undo_59 SET INACTIVE; |
| 193 |
ALTER UNDO TABLESPACE undo_60 SET INACTIVE; |
| 194 |
ALTER UNDO TABLESPACE undo_61 SET INACTIVE; |
| 195 |
ALTER UNDO TABLESPACE undo_62 SET INACTIVE; |
| 196 |
ALTER UNDO TABLESPACE undo_63 SET INACTIVE; |
| 197 |
ALTER UNDO TABLESPACE undo_64 SET INACTIVE; |
| 198 |
ALTER UNDO TABLESPACE undo_65 SET INACTIVE; |
| 199 |
ALTER UNDO TABLESPACE undo_66 SET INACTIVE; |
| 200 |
ALTER UNDO TABLESPACE undo_67 SET INACTIVE; |
| 201 |
ALTER UNDO TABLESPACE undo_68 SET INACTIVE; |
| 202 |
ALTER UNDO TABLESPACE undo_69 SET INACTIVE; |
| 203 |
ALTER UNDO TABLESPACE undo_70 SET INACTIVE; |
| 204 |
ALTER UNDO TABLESPACE undo_71 SET INACTIVE; |
| 205 |
ALTER UNDO TABLESPACE undo_72 SET INACTIVE; |
| 206 |
ALTER UNDO TABLESPACE undo_73 SET INACTIVE; |
| 207 |
ALTER UNDO TABLESPACE undo_74 SET INACTIVE; |
| 208 |
ALTER UNDO TABLESPACE undo_75 SET INACTIVE; |
| 209 |
ALTER UNDO TABLESPACE undo_76 SET INACTIVE; |
| 210 |
ALTER UNDO TABLESPACE undo_77 SET INACTIVE; |
| 211 |
ALTER UNDO TABLESPACE undo_78 SET INACTIVE; |
| 212 |
ALTER UNDO TABLESPACE undo_79 SET INACTIVE; |
| 213 |
ALTER UNDO TABLESPACE undo_80 SET INACTIVE; |
| 214 |
ALTER UNDO TABLESPACE undo_81 SET INACTIVE; |
| 215 |
ALTER UNDO TABLESPACE undo_82 SET INACTIVE; |
| 216 |
ALTER UNDO TABLESPACE undo_83 SET INACTIVE; |
| 217 |
ALTER UNDO TABLESPACE undo_84 SET INACTIVE; |
| 218 |
ALTER UNDO TABLESPACE undo_85 SET INACTIVE; |
| 219 |
ALTER UNDO TABLESPACE undo_86 SET INACTIVE; |
| 220 |
ALTER UNDO TABLESPACE undo_87 SET INACTIVE; |
| 221 |
ALTER UNDO TABLESPACE undo_88 SET INACTIVE; |
| 222 |
ALTER UNDO TABLESPACE undo_89 SET INACTIVE; |
| 223 |
ALTER UNDO TABLESPACE undo_90 SET INACTIVE; |
| 224 |
ALTER UNDO TABLESPACE undo_91 SET INACTIVE; |
| 225 |
ALTER UNDO TABLESPACE undo_92 SET INACTIVE; |
| 226 |
ALTER UNDO TABLESPACE undo_93 SET INACTIVE; |
| 227 |
ALTER UNDO TABLESPACE undo_94 SET INACTIVE; |
| 228 |
ALTER UNDO TABLESPACE undo_95 SET INACTIVE; |
| 229 |
ALTER UNDO TABLESPACE undo_96 SET INACTIVE; |
| 230 |
ALTER UNDO TABLESPACE undo_97 SET INACTIVE; |
| 231 |
ALTER UNDO TABLESPACE undo_98 SET INACTIVE; |
| 232 |
ALTER UNDO TABLESPACE undo_99 SET INACTIVE; |
| 233 |
ALTER UNDO TABLESPACE undo_100 SET INACTIVE; |
| 234 |
ALTER UNDO TABLESPACE undo_101 SET INACTIVE; |
| 235 |
ALTER UNDO TABLESPACE undo_102 SET INACTIVE; |
| 236 |
ALTER UNDO TABLESPACE undo_103 SET INACTIVE; |
| 237 |
ALTER UNDO TABLESPACE undo_104 SET INACTIVE; |
| 238 |
ALTER UNDO TABLESPACE undo_105 SET INACTIVE; |
| 239 |
ALTER UNDO TABLESPACE undo_106 SET INACTIVE; |
| 240 |
ALTER UNDO TABLESPACE undo_107 SET INACTIVE; |
| 241 |
ALTER UNDO TABLESPACE undo_108 SET INACTIVE; |
| 242 |
ALTER UNDO TABLESPACE undo_109 SET INACTIVE; |
| 243 |
ALTER UNDO TABLESPACE undo_110 SET INACTIVE; |
| 244 |
ALTER UNDO TABLESPACE undo_111 SET INACTIVE; |
| 245 |
ALTER UNDO TABLESPACE undo_112 SET INACTIVE; |
| 246 |
ALTER UNDO TABLESPACE undo_113 SET INACTIVE; |
| 247 |
ALTER UNDO TABLESPACE undo_114 SET INACTIVE; |
| 248 |
ALTER UNDO TABLESPACE undo_115 SET INACTIVE; |
| 249 |
ALTER UNDO TABLESPACE undo_116 SET INACTIVE; |
| 250 |
ALTER UNDO TABLESPACE undo_117 SET INACTIVE; |
| 251 |
ALTER UNDO TABLESPACE undo_118 SET INACTIVE; |
| 252 |
ALTER UNDO TABLESPACE undo_119 SET INACTIVE; |
| 253 |
ALTER UNDO TABLESPACE undo_120 SET INACTIVE; |
| 254 |
ALTER UNDO TABLESPACE undo_121 SET INACTIVE; |
| 255 |
ALTER UNDO TABLESPACE undo_122 SET INACTIVE; |
| 256 |
ALTER UNDO TABLESPACE undo_123 SET INACTIVE; |
| 257 |
ALTER UNDO TABLESPACE undo_124 SET INACTIVE; |
| 258 |
ALTER UNDO TABLESPACE undo_125 SET INACTIVE; |
| 259 |
ALTER UNDO TABLESPACE undo_126 SET INACTIVE; |
| 260 |
ALTER UNDO TABLESPACE undo_127 SET INACTIVE; |
| 261 |
# Wait for all explicit undo tablespaces to become empty. |
| 262 |
# Drop all explicit undo tablespaces. |
| 263 |
DROP UNDO TABLESPACE undo_3; |
| 264 |
DROP UNDO TABLESPACE undo_4; |
| 265 |
DROP UNDO TABLESPACE undo_5; |
| 266 |
DROP UNDO TABLESPACE undo_6; |
| 267 |
DROP UNDO TABLESPACE undo_7; |
| 268 |
DROP UNDO TABLESPACE undo_8; |
| 269 |
DROP UNDO TABLESPACE undo_9; |
| 270 |
DROP UNDO TABLESPACE undo_10; |
| 271 |
DROP UNDO TABLESPACE undo_11; |
| 272 |
DROP UNDO TABLESPACE undo_12; |
| 273 |
DROP UNDO TABLESPACE undo_13; |
| 274 |
DROP UNDO TABLESPACE undo_14; |
| 275 |
DROP UNDO TABLESPACE undo_15; |
| 276 |
DROP UNDO TABLESPACE undo_16; |
| 277 |
DROP UNDO TABLESPACE undo_17; |
| 278 |
DROP UNDO TABLESPACE undo_18; |
| 279 |
DROP UNDO TABLESPACE undo_19; |
| 280 |
DROP UNDO TABLESPACE undo_20; |
| 281 |
DROP UNDO TABLESPACE undo_21; |
| 282 |
DROP UNDO TABLESPACE undo_22; |
| 283 |
DROP UNDO TABLESPACE undo_23; |
| 284 |
DROP UNDO TABLESPACE undo_24; |
| 285 |
DROP UNDO TABLESPACE undo_25; |
| 286 |
DROP UNDO TABLESPACE undo_26; |
| 287 |
DROP UNDO TABLESPACE undo_27; |
| 288 |
DROP UNDO TABLESPACE undo_28; |
| 289 |
DROP UNDO TABLESPACE undo_29; |
| 290 |
DROP UNDO TABLESPACE undo_30; |
| 291 |
DROP UNDO TABLESPACE undo_31; |
| 292 |
DROP UNDO TABLESPACE undo_32; |
| 293 |
DROP UNDO TABLESPACE undo_33; |
| 294 |
DROP UNDO TABLESPACE undo_34; |
| 295 |
DROP UNDO TABLESPACE undo_35; |
| 296 |
DROP UNDO TABLESPACE undo_36; |
| 297 |
DROP UNDO TABLESPACE undo_37; |
| 298 |
DROP UNDO TABLESPACE undo_38; |
| 299 |
DROP UNDO TABLESPACE undo_39; |
| 300 |
DROP UNDO TABLESPACE undo_40; |
| 301 |
DROP UNDO TABLESPACE undo_41; |
| 302 |
DROP UNDO TABLESPACE undo_42; |
| 303 |
DROP UNDO TABLESPACE undo_43; |
| 304 |
DROP UNDO TABLESPACE undo_44; |
| 305 |
DROP UNDO TABLESPACE undo_45; |
| 306 |
DROP UNDO TABLESPACE undo_46; |
| 307 |
DROP UNDO TABLESPACE undo_47; |
| 308 |
DROP UNDO TABLESPACE undo_48; |
| 309 |
DROP UNDO TABLESPACE undo_49; |
| 310 |
DROP UNDO TABLESPACE undo_50; |
| 311 |
DROP UNDO TABLESPACE undo_51; |
| 312 |
DROP UNDO TABLESPACE undo_52; |
| 313 |
DROP UNDO TABLESPACE undo_53; |
| 314 |
DROP UNDO TABLESPACE undo_54; |
| 315 |
DROP UNDO TABLESPACE undo_55; |
| 316 |
DROP UNDO TABLESPACE undo_56; |
| 317 |
DROP UNDO TABLESPACE undo_57; |
| 318 |
DROP UNDO TABLESPACE undo_58; |
| 319 |
DROP UNDO TABLESPACE undo_59; |
| 320 |
DROP UNDO TABLESPACE undo_60; |
| 321 |
DROP UNDO TABLESPACE undo_61; |
| 322 |
DROP UNDO TABLESPACE undo_62; |
| 323 |
DROP UNDO TABLESPACE undo_63; |
| 324 |
DROP UNDO TABLESPACE undo_64; |
| 325 |
DROP UNDO TABLESPACE undo_65; |
| 326 |
DROP UNDO TABLESPACE undo_66; |
| 327 |
DROP UNDO TABLESPACE undo_67; |
| 328 |
DROP UNDO TABLESPACE undo_68; |
| 329 |
DROP UNDO TABLESPACE undo_69; |
| 330 |
DROP UNDO TABLESPACE undo_70; |
| 331 |
DROP UNDO TABLESPACE undo_71; |
| 332 |
DROP UNDO TABLESPACE undo_72; |
| 333 |
DROP UNDO TABLESPACE undo_73; |
| 334 |
DROP UNDO TABLESPACE undo_74; |
| 335 |
DROP UNDO TABLESPACE undo_75; |
| 336 |
DROP UNDO TABLESPACE undo_76; |
| 337 |
DROP UNDO TABLESPACE undo_77; |
| 338 |
DROP UNDO TABLESPACE undo_78; |
| 339 |
DROP UNDO TABLESPACE undo_79; |
| 340 |
DROP UNDO TABLESPACE undo_80; |
| 341 |
DROP UNDO TABLESPACE undo_81; |
| 342 |
DROP UNDO TABLESPACE undo_82; |
| 343 |
DROP UNDO TABLESPACE undo_83; |
| 344 |
DROP UNDO TABLESPACE undo_84; |
| 345 |
DROP UNDO TABLESPACE undo_85; |
| 346 |
DROP UNDO TABLESPACE undo_86; |
| 347 |
DROP UNDO TABLESPACE undo_87; |
| 348 |
DROP UNDO TABLESPACE undo_88; |
| 349 |
DROP UNDO TABLESPACE undo_89; |
| 350 |
DROP UNDO TABLESPACE undo_90; |
| 351 |
DROP UNDO TABLESPACE undo_91; |
| 352 |
DROP UNDO TABLESPACE undo_92; |
| 353 |
DROP UNDO TABLESPACE undo_93; |
| 354 |
DROP UNDO TABLESPACE undo_94; |
| 355 |
DROP UNDO TABLESPACE undo_95; |
| 356 |
DROP UNDO TABLESPACE undo_96; |
| 357 |
DROP UNDO TABLESPACE undo_97; |
| 358 |
DROP UNDO TABLESPACE undo_98; |
| 359 |
DROP UNDO TABLESPACE undo_99; |
| 360 |
DROP UNDO TABLESPACE undo_100; |
| 361 |
DROP UNDO TABLESPACE undo_101; |
| 362 |
DROP UNDO TABLESPACE undo_102; |
| 363 |
DROP UNDO TABLESPACE undo_103; |
| 364 |
DROP UNDO TABLESPACE undo_104; |
| 365 |
DROP UNDO TABLESPACE undo_105; |
| 366 |
DROP UNDO TABLESPACE undo_106; |
| 367 |
DROP UNDO TABLESPACE undo_107; |
| 368 |
DROP UNDO TABLESPACE undo_108; |
| 369 |
DROP UNDO TABLESPACE undo_109; |
| 370 |
DROP UNDO TABLESPACE undo_110; |
| 371 |
DROP UNDO TABLESPACE undo_111; |
| 372 |
DROP UNDO TABLESPACE undo_112; |
| 373 |
DROP UNDO TABLESPACE undo_113; |
| 374 |
DROP UNDO TABLESPACE undo_114; |
| 375 |
DROP UNDO TABLESPACE undo_115; |
| 376 |
DROP UNDO TABLESPACE undo_116; |
| 377 |
DROP UNDO TABLESPACE undo_117; |
| 378 |
DROP UNDO TABLESPACE undo_118; |
| 379 |
DROP UNDO TABLESPACE undo_119; |
| 380 |
DROP UNDO TABLESPACE undo_120; |
| 381 |
DROP UNDO TABLESPACE undo_121; |
| 382 |
DROP UNDO TABLESPACE undo_122; |
| 383 |
DROP UNDO TABLESPACE undo_123; |
| 384 |
DROP UNDO TABLESPACE undo_124; |
| 385 |
DROP UNDO TABLESPACE undo_125; |
| 386 |
DROP UNDO TABLESPACE undo_126; |
| 387 |
DROP UNDO TABLESPACE undo_127; |