polardbxengine/mysql-test/suite/innodb_undo/r/undo_tablespace_125.result

388 lines
17 KiB
Plaintext

#
# InnoDB supports CREATE/ALTER/DROP UNDO TABLESPACE
# Show that up to 125 explicit undo tablespaces can be created.
#
CREATE UNDO TABLESPACE undo_3 ADD DATAFILE 'undo_3.ibu';
CREATE UNDO TABLESPACE undo_4 ADD DATAFILE 'undo_4.ibu';
CREATE UNDO TABLESPACE undo_5 ADD DATAFILE 'undo_5.ibu';
CREATE UNDO TABLESPACE undo_6 ADD DATAFILE 'undo_6.ibu';
CREATE UNDO TABLESPACE undo_7 ADD DATAFILE 'undo_7.ibu';
CREATE UNDO TABLESPACE undo_8 ADD DATAFILE 'undo_8.ibu';
CREATE UNDO TABLESPACE undo_9 ADD DATAFILE 'undo_9.ibu';
CREATE UNDO TABLESPACE undo_10 ADD DATAFILE 'undo_10.ibu';
CREATE UNDO TABLESPACE undo_11 ADD DATAFILE 'undo_11.ibu';
CREATE UNDO TABLESPACE undo_12 ADD DATAFILE 'undo_12.ibu';
CREATE UNDO TABLESPACE undo_13 ADD DATAFILE 'undo_13.ibu';
CREATE UNDO TABLESPACE undo_14 ADD DATAFILE 'undo_14.ibu';
CREATE UNDO TABLESPACE undo_15 ADD DATAFILE 'undo_15.ibu';
CREATE UNDO TABLESPACE undo_16 ADD DATAFILE 'undo_16.ibu';
CREATE UNDO TABLESPACE undo_17 ADD DATAFILE 'undo_17.ibu';
CREATE UNDO TABLESPACE undo_18 ADD DATAFILE 'undo_18.ibu';
CREATE UNDO TABLESPACE undo_19 ADD DATAFILE 'undo_19.ibu';
CREATE UNDO TABLESPACE undo_20 ADD DATAFILE 'undo_20.ibu';
CREATE UNDO TABLESPACE undo_21 ADD DATAFILE 'undo_21.ibu';
CREATE UNDO TABLESPACE undo_22 ADD DATAFILE 'undo_22.ibu';
CREATE UNDO TABLESPACE undo_23 ADD DATAFILE 'undo_23.ibu';
CREATE UNDO TABLESPACE undo_24 ADD DATAFILE 'undo_24.ibu';
CREATE UNDO TABLESPACE undo_25 ADD DATAFILE 'undo_25.ibu';
CREATE UNDO TABLESPACE undo_26 ADD DATAFILE 'undo_26.ibu';
CREATE UNDO TABLESPACE undo_27 ADD DATAFILE 'undo_27.ibu';
CREATE UNDO TABLESPACE undo_28 ADD DATAFILE 'undo_28.ibu';
CREATE UNDO TABLESPACE undo_29 ADD DATAFILE 'undo_29.ibu';
CREATE UNDO TABLESPACE undo_30 ADD DATAFILE 'undo_30.ibu';
CREATE UNDO TABLESPACE undo_31 ADD DATAFILE 'undo_31.ibu';
CREATE UNDO TABLESPACE undo_32 ADD DATAFILE 'undo_32.ibu';
CREATE UNDO TABLESPACE undo_33 ADD DATAFILE 'undo_33.ibu';
CREATE UNDO TABLESPACE undo_34 ADD DATAFILE 'undo_34.ibu';
CREATE UNDO TABLESPACE undo_35 ADD DATAFILE 'undo_35.ibu';
CREATE UNDO TABLESPACE undo_36 ADD DATAFILE 'undo_36.ibu';
CREATE UNDO TABLESPACE undo_37 ADD DATAFILE 'undo_37.ibu';
CREATE UNDO TABLESPACE undo_38 ADD DATAFILE 'undo_38.ibu';
CREATE UNDO TABLESPACE undo_39 ADD DATAFILE 'undo_39.ibu';
CREATE UNDO TABLESPACE undo_40 ADD DATAFILE 'undo_40.ibu';
CREATE UNDO TABLESPACE undo_41 ADD DATAFILE 'undo_41.ibu';
CREATE UNDO TABLESPACE undo_42 ADD DATAFILE 'undo_42.ibu';
CREATE UNDO TABLESPACE undo_43 ADD DATAFILE 'undo_43.ibu';
CREATE UNDO TABLESPACE undo_44 ADD DATAFILE 'undo_44.ibu';
CREATE UNDO TABLESPACE undo_45 ADD DATAFILE 'undo_45.ibu';
CREATE UNDO TABLESPACE undo_46 ADD DATAFILE 'undo_46.ibu';
CREATE UNDO TABLESPACE undo_47 ADD DATAFILE 'undo_47.ibu';
CREATE UNDO TABLESPACE undo_48 ADD DATAFILE 'undo_48.ibu';
CREATE UNDO TABLESPACE undo_49 ADD DATAFILE 'undo_49.ibu';
CREATE UNDO TABLESPACE undo_50 ADD DATAFILE 'undo_50.ibu';
CREATE UNDO TABLESPACE undo_51 ADD DATAFILE 'undo_51.ibu';
CREATE UNDO TABLESPACE undo_52 ADD DATAFILE 'undo_52.ibu';
CREATE UNDO TABLESPACE undo_53 ADD DATAFILE 'undo_53.ibu';
CREATE UNDO TABLESPACE undo_54 ADD DATAFILE 'undo_54.ibu';
CREATE UNDO TABLESPACE undo_55 ADD DATAFILE 'undo_55.ibu';
CREATE UNDO TABLESPACE undo_56 ADD DATAFILE 'undo_56.ibu';
CREATE UNDO TABLESPACE undo_57 ADD DATAFILE 'undo_57.ibu';
CREATE UNDO TABLESPACE undo_58 ADD DATAFILE 'undo_58.ibu';
CREATE UNDO TABLESPACE undo_59 ADD DATAFILE 'undo_59.ibu';
CREATE UNDO TABLESPACE undo_60 ADD DATAFILE 'undo_60.ibu';
CREATE UNDO TABLESPACE undo_61 ADD DATAFILE 'undo_61.ibu';
CREATE UNDO TABLESPACE undo_62 ADD DATAFILE 'undo_62.ibu';
CREATE UNDO TABLESPACE undo_63 ADD DATAFILE 'undo_63.ibu';
CREATE UNDO TABLESPACE undo_64 ADD DATAFILE 'undo_64.ibu';
CREATE UNDO TABLESPACE undo_65 ADD DATAFILE 'undo_65.ibu';
CREATE UNDO TABLESPACE undo_66 ADD DATAFILE 'undo_66.ibu';
CREATE UNDO TABLESPACE undo_67 ADD DATAFILE 'undo_67.ibu';
CREATE UNDO TABLESPACE undo_68 ADD DATAFILE 'undo_68.ibu';
CREATE UNDO TABLESPACE undo_69 ADD DATAFILE 'undo_69.ibu';
CREATE UNDO TABLESPACE undo_70 ADD DATAFILE 'undo_70.ibu';
CREATE UNDO TABLESPACE undo_71 ADD DATAFILE 'undo_71.ibu';
CREATE UNDO TABLESPACE undo_72 ADD DATAFILE 'undo_72.ibu';
CREATE UNDO TABLESPACE undo_73 ADD DATAFILE 'undo_73.ibu';
CREATE UNDO TABLESPACE undo_74 ADD DATAFILE 'undo_74.ibu';
CREATE UNDO TABLESPACE undo_75 ADD DATAFILE 'undo_75.ibu';
CREATE UNDO TABLESPACE undo_76 ADD DATAFILE 'undo_76.ibu';
CREATE UNDO TABLESPACE undo_77 ADD DATAFILE 'undo_77.ibu';
CREATE UNDO TABLESPACE undo_78 ADD DATAFILE 'undo_78.ibu';
CREATE UNDO TABLESPACE undo_79 ADD DATAFILE 'undo_79.ibu';
CREATE UNDO TABLESPACE undo_80 ADD DATAFILE 'undo_80.ibu';
CREATE UNDO TABLESPACE undo_81 ADD DATAFILE 'undo_81.ibu';
CREATE UNDO TABLESPACE undo_82 ADD DATAFILE 'undo_82.ibu';
CREATE UNDO TABLESPACE undo_83 ADD DATAFILE 'undo_83.ibu';
CREATE UNDO TABLESPACE undo_84 ADD DATAFILE 'undo_84.ibu';
CREATE UNDO TABLESPACE undo_85 ADD DATAFILE 'undo_85.ibu';
CREATE UNDO TABLESPACE undo_86 ADD DATAFILE 'undo_86.ibu';
CREATE UNDO TABLESPACE undo_87 ADD DATAFILE 'undo_87.ibu';
CREATE UNDO TABLESPACE undo_88 ADD DATAFILE 'undo_88.ibu';
CREATE UNDO TABLESPACE undo_89 ADD DATAFILE 'undo_89.ibu';
CREATE UNDO TABLESPACE undo_90 ADD DATAFILE 'undo_90.ibu';
CREATE UNDO TABLESPACE undo_91 ADD DATAFILE 'undo_91.ibu';
CREATE UNDO TABLESPACE undo_92 ADD DATAFILE 'undo_92.ibu';
CREATE UNDO TABLESPACE undo_93 ADD DATAFILE 'undo_93.ibu';
CREATE UNDO TABLESPACE undo_94 ADD DATAFILE 'undo_94.ibu';
CREATE UNDO TABLESPACE undo_95 ADD DATAFILE 'undo_95.ibu';
CREATE UNDO TABLESPACE undo_96 ADD DATAFILE 'undo_96.ibu';
CREATE UNDO TABLESPACE undo_97 ADD DATAFILE 'undo_97.ibu';
CREATE UNDO TABLESPACE undo_98 ADD DATAFILE 'undo_98.ibu';
CREATE UNDO TABLESPACE undo_99 ADD DATAFILE 'undo_99.ibu';
CREATE UNDO TABLESPACE undo_100 ADD DATAFILE 'undo_100.ibu';
CREATE UNDO TABLESPACE undo_101 ADD DATAFILE 'undo_101.ibu';
CREATE UNDO TABLESPACE undo_102 ADD DATAFILE 'undo_102.ibu';
CREATE UNDO TABLESPACE undo_103 ADD DATAFILE 'undo_103.ibu';
CREATE UNDO TABLESPACE undo_104 ADD DATAFILE 'undo_104.ibu';
CREATE UNDO TABLESPACE undo_105 ADD DATAFILE 'undo_105.ibu';
CREATE UNDO TABLESPACE undo_106 ADD DATAFILE 'undo_106.ibu';
CREATE UNDO TABLESPACE undo_107 ADD DATAFILE 'undo_107.ibu';
CREATE UNDO TABLESPACE undo_108 ADD DATAFILE 'undo_108.ibu';
CREATE UNDO TABLESPACE undo_109 ADD DATAFILE 'undo_109.ibu';
CREATE UNDO TABLESPACE undo_110 ADD DATAFILE 'undo_110.ibu';
CREATE UNDO TABLESPACE undo_111 ADD DATAFILE 'undo_111.ibu';
CREATE UNDO TABLESPACE undo_112 ADD DATAFILE 'undo_112.ibu';
CREATE UNDO TABLESPACE undo_113 ADD DATAFILE 'undo_113.ibu';
CREATE UNDO TABLESPACE undo_114 ADD DATAFILE 'undo_114.ibu';
CREATE UNDO TABLESPACE undo_115 ADD DATAFILE 'undo_115.ibu';
CREATE UNDO TABLESPACE undo_116 ADD DATAFILE 'undo_116.ibu';
CREATE UNDO TABLESPACE undo_117 ADD DATAFILE 'undo_117.ibu';
CREATE UNDO TABLESPACE undo_118 ADD DATAFILE 'undo_118.ibu';
CREATE UNDO TABLESPACE undo_119 ADD DATAFILE 'undo_119.ibu';
CREATE UNDO TABLESPACE undo_120 ADD DATAFILE 'undo_120.ibu';
CREATE UNDO TABLESPACE undo_121 ADD DATAFILE 'undo_121.ibu';
CREATE UNDO TABLESPACE undo_122 ADD DATAFILE 'undo_122.ibu';
CREATE UNDO TABLESPACE undo_123 ADD DATAFILE 'undo_123.ibu';
CREATE UNDO TABLESPACE undo_124 ADD DATAFILE 'undo_124.ibu';
CREATE UNDO TABLESPACE undo_125 ADD DATAFILE 'undo_125.ibu';
CREATE UNDO TABLESPACE undo_126 ADD DATAFILE 'undo_126.ibu';
CREATE UNDO TABLESPACE undo_127 ADD DATAFILE 'undo_127.ibu';
CREATE UNDO TABLESPACE undo_128 ADD DATAFILE 'undo_128.ibu';
ERROR HY000: Failed to create UNDO TABLESPACE undo_128
SHOW WARNINGS;
Level Code Message
Error 1528 Failed to create UNDO TABLESPACE undo_128
Error 1813 Tablespace 'undo_128' exists.
ALTER UNDO TABLESPACE undo_3 SET INACTIVE;
ALTER UNDO TABLESPACE undo_4 SET INACTIVE;
ALTER UNDO TABLESPACE undo_5 SET INACTIVE;
ALTER UNDO TABLESPACE undo_6 SET INACTIVE;
ALTER UNDO TABLESPACE undo_7 SET INACTIVE;
ALTER UNDO TABLESPACE undo_8 SET INACTIVE;
ALTER UNDO TABLESPACE undo_9 SET INACTIVE;
ALTER UNDO TABLESPACE undo_10 SET INACTIVE;
ALTER UNDO TABLESPACE undo_11 SET INACTIVE;
ALTER UNDO TABLESPACE undo_12 SET INACTIVE;
ALTER UNDO TABLESPACE undo_13 SET INACTIVE;
ALTER UNDO TABLESPACE undo_14 SET INACTIVE;
ALTER UNDO TABLESPACE undo_15 SET INACTIVE;
ALTER UNDO TABLESPACE undo_16 SET INACTIVE;
ALTER UNDO TABLESPACE undo_17 SET INACTIVE;
ALTER UNDO TABLESPACE undo_18 SET INACTIVE;
ALTER UNDO TABLESPACE undo_19 SET INACTIVE;
ALTER UNDO TABLESPACE undo_20 SET INACTIVE;
ALTER UNDO TABLESPACE undo_21 SET INACTIVE;
ALTER UNDO TABLESPACE undo_22 SET INACTIVE;
ALTER UNDO TABLESPACE undo_23 SET INACTIVE;
ALTER UNDO TABLESPACE undo_24 SET INACTIVE;
ALTER UNDO TABLESPACE undo_25 SET INACTIVE;
ALTER UNDO TABLESPACE undo_26 SET INACTIVE;
ALTER UNDO TABLESPACE undo_27 SET INACTIVE;
ALTER UNDO TABLESPACE undo_28 SET INACTIVE;
ALTER UNDO TABLESPACE undo_29 SET INACTIVE;
ALTER UNDO TABLESPACE undo_30 SET INACTIVE;
ALTER UNDO TABLESPACE undo_31 SET INACTIVE;
ALTER UNDO TABLESPACE undo_32 SET INACTIVE;
ALTER UNDO TABLESPACE undo_33 SET INACTIVE;
ALTER UNDO TABLESPACE undo_34 SET INACTIVE;
ALTER UNDO TABLESPACE undo_35 SET INACTIVE;
ALTER UNDO TABLESPACE undo_36 SET INACTIVE;
ALTER UNDO TABLESPACE undo_37 SET INACTIVE;
ALTER UNDO TABLESPACE undo_38 SET INACTIVE;
ALTER UNDO TABLESPACE undo_39 SET INACTIVE;
ALTER UNDO TABLESPACE undo_40 SET INACTIVE;
ALTER UNDO TABLESPACE undo_41 SET INACTIVE;
ALTER UNDO TABLESPACE undo_42 SET INACTIVE;
ALTER UNDO TABLESPACE undo_43 SET INACTIVE;
ALTER UNDO TABLESPACE undo_44 SET INACTIVE;
ALTER UNDO TABLESPACE undo_45 SET INACTIVE;
ALTER UNDO TABLESPACE undo_46 SET INACTIVE;
ALTER UNDO TABLESPACE undo_47 SET INACTIVE;
ALTER UNDO TABLESPACE undo_48 SET INACTIVE;
ALTER UNDO TABLESPACE undo_49 SET INACTIVE;
ALTER UNDO TABLESPACE undo_50 SET INACTIVE;
ALTER UNDO TABLESPACE undo_51 SET INACTIVE;
ALTER UNDO TABLESPACE undo_52 SET INACTIVE;
ALTER UNDO TABLESPACE undo_53 SET INACTIVE;
ALTER UNDO TABLESPACE undo_54 SET INACTIVE;
ALTER UNDO TABLESPACE undo_55 SET INACTIVE;
ALTER UNDO TABLESPACE undo_56 SET INACTIVE;
ALTER UNDO TABLESPACE undo_57 SET INACTIVE;
ALTER UNDO TABLESPACE undo_58 SET INACTIVE;
ALTER UNDO TABLESPACE undo_59 SET INACTIVE;
ALTER UNDO TABLESPACE undo_60 SET INACTIVE;
ALTER UNDO TABLESPACE undo_61 SET INACTIVE;
ALTER UNDO TABLESPACE undo_62 SET INACTIVE;
ALTER UNDO TABLESPACE undo_63 SET INACTIVE;
ALTER UNDO TABLESPACE undo_64 SET INACTIVE;
ALTER UNDO TABLESPACE undo_65 SET INACTIVE;
ALTER UNDO TABLESPACE undo_66 SET INACTIVE;
ALTER UNDO TABLESPACE undo_67 SET INACTIVE;
ALTER UNDO TABLESPACE undo_68 SET INACTIVE;
ALTER UNDO TABLESPACE undo_69 SET INACTIVE;
ALTER UNDO TABLESPACE undo_70 SET INACTIVE;
ALTER UNDO TABLESPACE undo_71 SET INACTIVE;
ALTER UNDO TABLESPACE undo_72 SET INACTIVE;
ALTER UNDO TABLESPACE undo_73 SET INACTIVE;
ALTER UNDO TABLESPACE undo_74 SET INACTIVE;
ALTER UNDO TABLESPACE undo_75 SET INACTIVE;
ALTER UNDO TABLESPACE undo_76 SET INACTIVE;
ALTER UNDO TABLESPACE undo_77 SET INACTIVE;
ALTER UNDO TABLESPACE undo_78 SET INACTIVE;
ALTER UNDO TABLESPACE undo_79 SET INACTIVE;
ALTER UNDO TABLESPACE undo_80 SET INACTIVE;
ALTER UNDO TABLESPACE undo_81 SET INACTIVE;
ALTER UNDO TABLESPACE undo_82 SET INACTIVE;
ALTER UNDO TABLESPACE undo_83 SET INACTIVE;
ALTER UNDO TABLESPACE undo_84 SET INACTIVE;
ALTER UNDO TABLESPACE undo_85 SET INACTIVE;
ALTER UNDO TABLESPACE undo_86 SET INACTIVE;
ALTER UNDO TABLESPACE undo_87 SET INACTIVE;
ALTER UNDO TABLESPACE undo_88 SET INACTIVE;
ALTER UNDO TABLESPACE undo_89 SET INACTIVE;
ALTER UNDO TABLESPACE undo_90 SET INACTIVE;
ALTER UNDO TABLESPACE undo_91 SET INACTIVE;
ALTER UNDO TABLESPACE undo_92 SET INACTIVE;
ALTER UNDO TABLESPACE undo_93 SET INACTIVE;
ALTER UNDO TABLESPACE undo_94 SET INACTIVE;
ALTER UNDO TABLESPACE undo_95 SET INACTIVE;
ALTER UNDO TABLESPACE undo_96 SET INACTIVE;
ALTER UNDO TABLESPACE undo_97 SET INACTIVE;
ALTER UNDO TABLESPACE undo_98 SET INACTIVE;
ALTER UNDO TABLESPACE undo_99 SET INACTIVE;
ALTER UNDO TABLESPACE undo_100 SET INACTIVE;
ALTER UNDO TABLESPACE undo_101 SET INACTIVE;
ALTER UNDO TABLESPACE undo_102 SET INACTIVE;
ALTER UNDO TABLESPACE undo_103 SET INACTIVE;
ALTER UNDO TABLESPACE undo_104 SET INACTIVE;
ALTER UNDO TABLESPACE undo_105 SET INACTIVE;
ALTER UNDO TABLESPACE undo_106 SET INACTIVE;
ALTER UNDO TABLESPACE undo_107 SET INACTIVE;
ALTER UNDO TABLESPACE undo_108 SET INACTIVE;
ALTER UNDO TABLESPACE undo_109 SET INACTIVE;
ALTER UNDO TABLESPACE undo_110 SET INACTIVE;
ALTER UNDO TABLESPACE undo_111 SET INACTIVE;
ALTER UNDO TABLESPACE undo_112 SET INACTIVE;
ALTER UNDO TABLESPACE undo_113 SET INACTIVE;
ALTER UNDO TABLESPACE undo_114 SET INACTIVE;
ALTER UNDO TABLESPACE undo_115 SET INACTIVE;
ALTER UNDO TABLESPACE undo_116 SET INACTIVE;
ALTER UNDO TABLESPACE undo_117 SET INACTIVE;
ALTER UNDO TABLESPACE undo_118 SET INACTIVE;
ALTER UNDO TABLESPACE undo_119 SET INACTIVE;
ALTER UNDO TABLESPACE undo_120 SET INACTIVE;
ALTER UNDO TABLESPACE undo_121 SET INACTIVE;
ALTER UNDO TABLESPACE undo_122 SET INACTIVE;
ALTER UNDO TABLESPACE undo_123 SET INACTIVE;
ALTER UNDO TABLESPACE undo_124 SET INACTIVE;
ALTER UNDO TABLESPACE undo_125 SET INACTIVE;
ALTER UNDO TABLESPACE undo_126 SET INACTIVE;
ALTER UNDO TABLESPACE undo_127 SET INACTIVE;
# Wait for all explicit undo tablespaces to become empty.
# Drop all explicit undo tablespaces.
DROP UNDO TABLESPACE undo_3;
DROP UNDO TABLESPACE undo_4;
DROP UNDO TABLESPACE undo_5;
DROP UNDO TABLESPACE undo_6;
DROP UNDO TABLESPACE undo_7;
DROP UNDO TABLESPACE undo_8;
DROP UNDO TABLESPACE undo_9;
DROP UNDO TABLESPACE undo_10;
DROP UNDO TABLESPACE undo_11;
DROP UNDO TABLESPACE undo_12;
DROP UNDO TABLESPACE undo_13;
DROP UNDO TABLESPACE undo_14;
DROP UNDO TABLESPACE undo_15;
DROP UNDO TABLESPACE undo_16;
DROP UNDO TABLESPACE undo_17;
DROP UNDO TABLESPACE undo_18;
DROP UNDO TABLESPACE undo_19;
DROP UNDO TABLESPACE undo_20;
DROP UNDO TABLESPACE undo_21;
DROP UNDO TABLESPACE undo_22;
DROP UNDO TABLESPACE undo_23;
DROP UNDO TABLESPACE undo_24;
DROP UNDO TABLESPACE undo_25;
DROP UNDO TABLESPACE undo_26;
DROP UNDO TABLESPACE undo_27;
DROP UNDO TABLESPACE undo_28;
DROP UNDO TABLESPACE undo_29;
DROP UNDO TABLESPACE undo_30;
DROP UNDO TABLESPACE undo_31;
DROP UNDO TABLESPACE undo_32;
DROP UNDO TABLESPACE undo_33;
DROP UNDO TABLESPACE undo_34;
DROP UNDO TABLESPACE undo_35;
DROP UNDO TABLESPACE undo_36;
DROP UNDO TABLESPACE undo_37;
DROP UNDO TABLESPACE undo_38;
DROP UNDO TABLESPACE undo_39;
DROP UNDO TABLESPACE undo_40;
DROP UNDO TABLESPACE undo_41;
DROP UNDO TABLESPACE undo_42;
DROP UNDO TABLESPACE undo_43;
DROP UNDO TABLESPACE undo_44;
DROP UNDO TABLESPACE undo_45;
DROP UNDO TABLESPACE undo_46;
DROP UNDO TABLESPACE undo_47;
DROP UNDO TABLESPACE undo_48;
DROP UNDO TABLESPACE undo_49;
DROP UNDO TABLESPACE undo_50;
DROP UNDO TABLESPACE undo_51;
DROP UNDO TABLESPACE undo_52;
DROP UNDO TABLESPACE undo_53;
DROP UNDO TABLESPACE undo_54;
DROP UNDO TABLESPACE undo_55;
DROP UNDO TABLESPACE undo_56;
DROP UNDO TABLESPACE undo_57;
DROP UNDO TABLESPACE undo_58;
DROP UNDO TABLESPACE undo_59;
DROP UNDO TABLESPACE undo_60;
DROP UNDO TABLESPACE undo_61;
DROP UNDO TABLESPACE undo_62;
DROP UNDO TABLESPACE undo_63;
DROP UNDO TABLESPACE undo_64;
DROP UNDO TABLESPACE undo_65;
DROP UNDO TABLESPACE undo_66;
DROP UNDO TABLESPACE undo_67;
DROP UNDO TABLESPACE undo_68;
DROP UNDO TABLESPACE undo_69;
DROP UNDO TABLESPACE undo_70;
DROP UNDO TABLESPACE undo_71;
DROP UNDO TABLESPACE undo_72;
DROP UNDO TABLESPACE undo_73;
DROP UNDO TABLESPACE undo_74;
DROP UNDO TABLESPACE undo_75;
DROP UNDO TABLESPACE undo_76;
DROP UNDO TABLESPACE undo_77;
DROP UNDO TABLESPACE undo_78;
DROP UNDO TABLESPACE undo_79;
DROP UNDO TABLESPACE undo_80;
DROP UNDO TABLESPACE undo_81;
DROP UNDO TABLESPACE undo_82;
DROP UNDO TABLESPACE undo_83;
DROP UNDO TABLESPACE undo_84;
DROP UNDO TABLESPACE undo_85;
DROP UNDO TABLESPACE undo_86;
DROP UNDO TABLESPACE undo_87;
DROP UNDO TABLESPACE undo_88;
DROP UNDO TABLESPACE undo_89;
DROP UNDO TABLESPACE undo_90;
DROP UNDO TABLESPACE undo_91;
DROP UNDO TABLESPACE undo_92;
DROP UNDO TABLESPACE undo_93;
DROP UNDO TABLESPACE undo_94;
DROP UNDO TABLESPACE undo_95;
DROP UNDO TABLESPACE undo_96;
DROP UNDO TABLESPACE undo_97;
DROP UNDO TABLESPACE undo_98;
DROP UNDO TABLESPACE undo_99;
DROP UNDO TABLESPACE undo_100;
DROP UNDO TABLESPACE undo_101;
DROP UNDO TABLESPACE undo_102;
DROP UNDO TABLESPACE undo_103;
DROP UNDO TABLESPACE undo_104;
DROP UNDO TABLESPACE undo_105;
DROP UNDO TABLESPACE undo_106;
DROP UNDO TABLESPACE undo_107;
DROP UNDO TABLESPACE undo_108;
DROP UNDO TABLESPACE undo_109;
DROP UNDO TABLESPACE undo_110;
DROP UNDO TABLESPACE undo_111;
DROP UNDO TABLESPACE undo_112;
DROP UNDO TABLESPACE undo_113;
DROP UNDO TABLESPACE undo_114;
DROP UNDO TABLESPACE undo_115;
DROP UNDO TABLESPACE undo_116;
DROP UNDO TABLESPACE undo_117;
DROP UNDO TABLESPACE undo_118;
DROP UNDO TABLESPACE undo_119;
DROP UNDO TABLESPACE undo_120;
DROP UNDO TABLESPACE undo_121;
DROP UNDO TABLESPACE undo_122;
DROP UNDO TABLESPACE undo_123;
DROP UNDO TABLESPACE undo_124;
DROP UNDO TABLESPACE undo_125;
DROP UNDO TABLESPACE undo_126;
DROP UNDO TABLESPACE undo_127;