Oracle error al borrar registros

Buenos Días Experto

Necesito de tu ayuda urgente en vista que tengo una tabla de 12´0 millones de registros de los cuales requiero de forma urgente borrar un 1 millón pero las consultas que utilizo se pueden demorar días procesando y jamas envía confirmación, las cosas que he verificado son las siguientes:

-Ejecutar la consulta con el usuario system

-utilizar la consulta con la clausula in, any

-cree una tabla temporal y anide el delete con select y dentro del select un inner join

-utilice otros campos diferentes a los PORQUE

esta es mi consulta

DELETE FROM crmtp_clientes WHERE ID_LISTA in (
626,653,655,688,689,692,719,722,773,774,812,857,869,966,972,1137,1150,1222,1237,1307,1338,1420,1430,1507,1531,1597,1600,1702,1727,1798,1814,1877,1907,1919,1951,2064,2097,2109,2201,2290,2291,2327,2460,1593,1603,1605,1606,1618,1687,1700,1725,1728,1729,1732,1741,1757,1786,1793,1800,1801,1802,1803,1822,1900,1913,1915,1937,
1942,1943,2070,2074,2075,2091,2092,2226,54,71,72,73,74,80,83,89,90,92,107,110,111,115,116,117,118,119,120,143,147,148,173,174,227,228,229,244,245,247,248,249,250,251,252,253,254,255,262,275,277,287,296,301,304,316,342,343,344,348,351,360,380,397,450,466,488,508,509,524,540,558,570,573,587,594,598,600,604,648,659,660,670,685,704,705,720,723,729,756,772,831,851,885,971,998,1105,1157,1170,1180,1215,1247,
1253,1277,1302,1320,1357,1403,1426,1459,1501,1502,1536,1537,1583,1648,1649,1701,1738,1789,1812,1813,1844,1914,1922,1964,1966,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,732,755,759,764,765,766,767,768,769,775,777,780,784,787,790,791,793,799,801,802,803,809,810,815,816,817,821,822,830,833,835,838,
839,845,846,847,848,849,854,858,859,868,877,881,890,900,909,910,912,918,919,924,925,926,931,932,933,939,940,945,946,953,954,958,964,967,968,983,992,993,994,1000,1004,1006,1012,1079,1081,1082,1083,1099,1103,1104,1110,1111,1113,1124,1125,1126,1132,1134,1144,1145,1146,1147,1149,1151,1155,1159,1161,1162,1163,1167,1172,1177,1178,1183,1184,1185,1192,1193,1197,1201,1202,1203,1204,1207,1208,1210,1216,1217,1218,1219,1228,1233,1241,1242,1243,1244,1248,1250,1262,1263,1264,1265,1266,1273,1275,1280,1288,1290,1291,1292,1293,1294,1298,1299,1304,1328,1334,1343,1345,1349,
1351,1352,1358,1359,1361,1362,1365,1374,1376,1377,1378,1384,1386,1390,1393,1394,1395,1396,1398,1410,1411890,1935,2073);