DECLARE
  N_JOBS_RUNNING NUMBER := 1;
BEGIN
SELECT COUNT(*) INTO N_JOBS_RUNNING FROM USER_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'T_DIM_ENT_IDX_%';
  WHILE N_JOBS_RUNNING<>0 LOOP
    DBMS_LOCK.SLEEP(5);
    SELECT COUNT(*) INTO N_JOBS_RUNNING FROM USER_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'T_DIM_ENT_IDX_%';
  END LOOP;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_U_1';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_2';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_3';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_4';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_5';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_6';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_7';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_8';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_9';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_10';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_11';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_12';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_13';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_14';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_15';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_16';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_17';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_18';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_19';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_20';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_21';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_22';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_23';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_24';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_25';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_26';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_27';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_28';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_29';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_34';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_35';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_36';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_37';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX T_DIM_ENT_IDX_38';
    EXCEPTION WHEN OTHERS THEN NULL;
  END;
END;