SQL> SQL> declare 2 begin 3 MERGE INTO ABSSOLUTE.sqlscript s USING (SELECT 'deleteITables.bf8aa852a87.sql' scriptname from dual) d ON (d.scriptname = s.scriptname) 4 WHEN MATCHED THEN UPDATE SET s.issuccessful = 'N', s.modifieddate = sysdate 5 WHEN NOT MATCHED THEN INSERT (s.scriptname, s.issuccessful, s.createddate) VALUES ('deleteITables.bf8aa852a87.sql', 'N', sysdate); 6 end; 7 / PL/SQL procedure successfully completed. SQL> commit; Commit complete. SQL> SQL> set serveroutput on size 100000 SQL> @"C:\ABSSolute\Live\01\Server\sqlscripts\deleteITables.bf8aa852a87.3469457889629139626.tmp" SQL> declare 2 c clob := ''; 3 begin 4 dbms_output.enable(buffer_size => null); 5 c := c || '------------drop i-table script BEGIN-------- 6 ---Version 04-JUN-2020 7 ---remark run whole script, ignore errors when table or trigger did not exist!--- 8 ---Drop triggers 9 declare 10 begin 11 execute immediate ''drop trigger trg_i_customerach''; 12 exception 13 when others then 14 null; 15 end; 16 declare 17 begin 18 execute immediate ''drop trigger i_productlistpercustomer_tom''; 19 exception 20 when others then 21 null; 22 end; 23 declare 24 begin 25 execute immediate ''drop trigger i_productsize_tom''; 26 exception 27 when others then 28 null; 29 end; 30 declare 31 begin 32 execute immediate ''drop trigger i_uniquepool_tom''; 33 exception 34 when others then 35 null; 36 end; 37 declare 38 begin 39 execute immediate ''drop trigger i_uniqueitem_pool''; 40 exception 41 when others then 42 null; 43 end; 44 declare 45 begin 46 execute immediate ''drop trigger trg_i_uniqueitem_tom''; 47 exception 48 when others then 49 null; 50 end; 51 begin 52 execute immediate ''drop trigger I_CONTRACTPRODUCT_TOM''; 53 exception 54 when others then 55 null; 56 end; 57 ---Drop tables 58 begin 59 execute immediate ''drop table I_CONTRACTEMBLEMTEMPLATE''; 60 exception 61 when others then 62 null; 63 end; 64 begin 65 execute immediate ''drop table I_CONTRACTPOCUSTOMER''; 66 exception 67 when others then 68 null; 69 end; 70 begin 71 execute immediate ''drop table I_CONTRACTPURCHASEORDERLINE''; 72 exception 73 when others then 74 null; 75 end; 76 begin 77 execute immediate ''drop table I_CONTRACTPURCHASEORDER''; 78 exception 79 when others then 80 null; 81 end; 82 begin 83 execute immediate ''drop table I_DEPOT''; 84 exception 85 when others then 86 null; 87 end; 88 begin 89 execute immediate ''drop table I_BUSINESSUNIT''; 90 exception 91 when others then 92 null; 93 end; 94 begin 95 execute immediate ''drop table I_PLANT''; 96 exception 97 when others then 98 null; 99 end; 100 declare 101 begin 102 execute immediate ''drop table I_CONTRACTPRODUCTQMGROUP''; 103 exception 104 when others then 105 null; 106 end; 107 declare 108 begin 109 execute immediate ''drop table I_CONTRACTPRODUCT''; 110 exception 111 when others then 112 null; 113 end; 114 declare 115 begin 116 execute immediate ''drop table I_CONTRACTCOMPONENT''; 117 exception 118 when others then 119 null; 120 end; 121 declare 122 begin 123 execute immediate ''drop table I_PRODUCTCONVERSIONSIZE''; 124 exception 125 when others then 126 null; 127 end; 128 declare 129 begin 130 execute immediate ''drop table I_LOCKER''; 131 exception 132 when others then 133 null; 134 end; 135 declare 136 begin 137 execute immediate ''drop table I_WEBUSERCUSTOMER''; 138 exception 139 when others then 140 null; 141 end; 142 declare 143 begin 144 execute immediate ''drop table I_WEBUSER''; 145 exception 146 when others then 147 null; 148 end; 149 declare 150 begin 151 execute immediate ''drop table I_NOBUDGETCLIENT''; 152 exception 153 when others then 154 null; 155 end; 156 declare 157 begin 158 execute immediate ''drop table I_NOBUDGETDEPARTMENT''; 159 exception 160 when others then 161 null; 162 end; 163 declare 164 begin 165 execute immediate ''drop table I_SUPPLIER''; 166 exception 167 when others then 168 null; 169 end; 170 begin 171 execute immediate ''drop table I_SCANHISTORY''; 172 exception 173 when others then 174 null; 175 end; 176 begin 177 execute immediate ''drop table I_FIXEDWEARERS''; 178 exception 179 when others then 180 null; 181 end; 182 begin 183 execute immediate ''drop table I_STOCKROOMLOCATION''; 184 exception 185 when others then 186 null; 187 end; 188 begin 189 execute immediate ''drop table I_CUSTOMERPREPCHARGE''; 190 exception 191 when others then 192 null; 193 end; 194 begin 195 execute immediate ''drop table I_TURNOVERGROUP''; 196 exception 197 when others then 198 null; 199 end; 200 begin 201 execute immediate ''drop table I_CUSTOMERCREDITCARD''; 202 exception 203 when others then 204 null; 205 end; 206 drop table I_DIALOGFLEXFLIELDS; 207 drop table I_IMAGE; 208 drop table I_STOCKCOUNTSCHEDULEDAY; 209 drop table I_STOCKCOUNTSCHEDULEDIST; 210 drop table I_STOCKCOUNTSCHEDULE; 211 drop table I_PURCHASEORDERHEADER; 212 drop table I_PURCHASEORDERLINE; 213 drop table I_PACKINGNOTELINECONTENT; 214 drop table I_PACKINGNOTECONTAINER; 215 drop table I_PACKINGNOTELINE; 216 drop table I_PACKINGNOTE; 217 drop table I_UNIQUEORPACKCONTENTS; 218 drop table I_CASHAPPLICATION; 219 drop table I_COSTPRICELIST; 220 drop table I_ALTERNATIVESIZES; 221 drop table I_STDLOCATIONPERPRODUCTSIZE; 222 drop table I_UNIQUEITEMLOSS; 223 drop table I_NONBUSINESSDAY; 224 drop table I_ARTRANSACTION; 225 drop table I_TEMPORARYDELIVERYSTOP; 226 drop table I_CHANGESPERWEEKRENTPRICE; 227 declare 228 begin 229 execute immediate ''drop table I_CONTACTCALLS_FOLLOWUP''; 230 exception 231 when others then 232 null; 233 end; 234 drop table I_CONTACTCALLS; 235 drop table I_CONTAINER; 236 drop table I_CONTRACTCUSTOMER; 237 drop table I_CONTRACTPRICELIST; 238 declare 239 begin 240 execute immediate ''drop table I_CONTRACTPRICE''; 241 exception 242 when others then 243 null; 244 end; 245 declare 246 begin 247 execute immediate ''drop table I_CONTRACTATTRIBUTE''; 248 exception 249 when others then 250 null; 251 end; 252 drop table I_CONTRACT; 253 drop table I_CREDITCARD; 254 drop table I_CUSTOMERACTIVITIES; 255 drop table I_CUSTOMERENVINFO; 256 drop table I_CUSTOMERSTOCKCHARGE; 257 drop table I_CUSTOMERUSERINSTRUCTION; 258 drop table I_DELIVERYDAYS; 259 drop table I_DELIVERYHISTORY; 260 drop table I_DELIVERYVARIATION; 261 drop table I_EMBLEM; 262 drop table I_EMBLEMTEMPLATE; 263 drop table I_FREQUENCYRELATEDRENTPRICES; 264 drop table I_SOILTICKETLINE; 265 drop table I_SOILTICKET; 266 declare 267 begin 268 execute immediate ''drop table I_CUSTOMERIMAGECAREPRICE''; 269 exception 270 when others then 271 null; 272 end; 273 declare 274 begin 275 execute immediate ''drop table I_CUSTOMERSURVEY''; 276 exception 277 when others then 278 null; 279 end; 280 declare 281 begin 282 execute immediate ''drop table I_INVOICELINE''; 283 exception 284 when others then 285 null; 286 end; 287 drop table I_INVOICEHEADER; 288 drop table I_MATORDERINGINFO; 289 drop table I_MISCCHARGE; 290 drop table I_MISCELLANEOUS; 291 drop table I_ONSITEINVADJUSTMENT; 292 drop table I_PACKCONTENTSALTERNATIVE; 293 drop table I_PACKCONTENT; 294 drop table I_PRICELISTPERCUSTOMER; 295 drop table I_PRICELIST; 296 drop table I_RESIDENTIALPLPC; 297 drop table I_SCAN; 298 drop table I_SOILREASONABILITY; 299 drop table I_SPECIALCHARGEPERPRODUCT; 300 drop table I_SPECIALCHARGESPERCUSTOMER; 301 drop table I_STANDARDINVENTORY; 302 drop table I_DELIVERYSTANDARDS; 303 drop table I_STOCKDEFINITIONPERITEM; 304 drop table I_STOCKROOMQUANTITY; 305 drop table I_SUPPLIERPRODUCT; 306 drop table I_TAXAUTHORITIES; 307 drop table I_TAXDEFINITION; 308 drop table I_TURNOVER_PLPC; 309 drop table I_UNIQUEITEMFLAGS; 310 drop table I_UNIQUEORSTERILE; 311 drop table I_UNIQUEORPACK; 312 drop table I_UNIQUEPOOL; 313 drop table I_UNIQUERESITEM; 314 drop table I_UNIQUEITEM; 315 drop table I_ACTIVESTOCKLOCATION; 316 drop table I_USERDEFINEDEMBLEM; 317 drop table I_WORKORDERLINE; 318 drop table I_WORKORDER; 319 drop table I_WEARERINVENTORY; 320 drop table I_WEARER; 321 drop table I_WEIGHINGCATEGPERCUSTOMER; 322 drop table I_PRODUCTLISTPERCUSTOMER; 323 drop table I_PRODUCTSIZE; 324 declare 325 begin 326 execute immediate ''drop table I_CUSTOMERBGPROTECTIONPRICE''; 327 exception 328 when others then 329 null; 330 end; 331 drop table I_PRODUCT; 332 drop table I_DELIVERYPOINT; 333 drop table I_COSTCENTER; 334 drop table I_CONSUMPTIONPOINT; 335 drop table I_CLIENT; 336 drop table I_DEPARTMENT; 337 drop table I_VISITMONTH; 338 declare 339 begin 340 execute immediate ''drop table I_BDECUSTOMER''; 341 exception 342 when others then 343 null; 344 end; 345 drop table I_BILLTOACCOUNT; 346 drop table I_CONTACTPERSON; 347 drop table I_CUSTOMERRESIDENTIALSETTINGS; 348 declare 349 begin 350 execute immediate ''drop table I_CUSTOMERBUDGETDEFINITION''; 351 exception 352 when others then 353 null; 354 end; 355 declare 356 begin 357 execute immediate ''drop table I_PAYBYCUSTOMER''; 358 exception 359 when others then 360 null; 361 end; 362 declare 363 begin 364 execute immediate ''drop table I_CUSTOMERACH''; 365 exception 366 when others then 367 null; 368 end; 369 drop table I_CUSTOMER; 370 -----------drop i-table script END -------- 371 '; 372 ABSSOLUTE.Pack_Script.execScriptFile(c, 'deleteITables.bf8aa852a87.sql'); 373 end; 374 / Remove_trigger: trigger trg_i_customerach dropped. Remove_trigger: trigger i_productlistpercustomer_tom dropped. Remove_trigger: trigger i_productsize_tom dropped. Remove_trigger: trigger i_uniquepool_tom dropped. Remove_trigger: trigger i_uniqueitem_pool not exist. Remove_trigger: trigger trg_i_uniqueitem_tom dropped. Remove_trigger: trigger I_CONTRACTPRODUCT_TOM dropped. Remove_Table: Table I_CONTRACTEMBLEMTEMPLATE dropped. Remove_Table: Table I_CONTRACTPOCUSTOMER dropped. Remove_Table: Table I_CONTRACTPURCHASEORDERLINE dropped. Remove_Table: Table I_CONTRACTPURCHASEORDER dropped. Remove_Table: Table I_DEPOT dropped. Remove_Table: Table I_BUSINESSUNIT dropped. Remove_Table: Table I_PLANT dropped. Remove_Table: Table I_CONTRACTPRODUCTQMGROUP dropped. Remove_Table: Table I_CONTRACTPRODUCT dropped. Remove_Table: Table I_CONTRACTCOMPONENT dropped. Remove_Table: Table I_PRODUCTCONVERSIONSIZE dropped. Remove_Table: Table I_LOCKER dropped. Remove_Table: Table I_WEBUSERCUSTOMER dropped. Remove_Table: Table I_WEBUSER dropped. Remove_Table: Table I_NOBUDGETCLIENT dropped. Remove_Table: Table I_NOBUDGETDEPARTMENT dropped. Remove_Table: Table I_SUPPLIER dropped. Remove_Table: Table I_SCANHISTORY dropped. Remove_Table: Table I_FIXEDWEARERS dropped. Remove_Table: Table I_STOCKROOMLOCATION dropped. Remove_Table: Table I_CUSTOMERPREPCHARGE dropped. Remove_Table: Table I_TURNOVERGROUP dropped. Remove_Table: Table I_CUSTOMERCREDITCARD dropped. Remove_Table: Table I_DIALOGFLEXFLIELDS dropped. Remove_Table: Table I_IMAGE dropped. Remove_Table: Table I_STOCKCOUNTSCHEDULEDAY dropped. Remove_Table: Table I_STOCKCOUNTSCHEDULEDIST dropped. Remove_Table: Table I_STOCKCOUNTSCHEDULE dropped. Remove_Table: Table I_PURCHASEORDERHEADER dropped. Remove_Table: Table I_PURCHASEORDERLINE dropped. Remove_Table: Table I_PACKINGNOTELINECONTENT dropped. Remove_Table: Table I_PACKINGNOTECONTAINER dropped. Remove_Table: Table I_PACKINGNOTELINE dropped. Remove_Table generates error when executing: DROP TABLE I_PACKINGNOTE ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired declare * ERROR at line 1: ORA-20002: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired ORA-06512: at "ABSSOLUTE.PACK_SCRIPT", line 2361 ORA-06512: at line 372