gistfile1.txt

BEGIN 

    BEGIN  EXECUTE IMMEDIATE 'DROP TABLE confluence.bandana_tmp';
    EXCEPTION WHEN OTHERS THEN dbms_output.put_line('Not Dropped'); END;

    EXECUTE IMMEDIATE 'CREATE TABLE confluence.bandana_tmp AS SELECT * FROM confluence.bandana WHERE ROWNUM < 2';
    EXECUTE IMMEDIATE 'DELETE FROM bandana_tmp';

    FOR a IN ( 
          SELECT ROWNUM, a.bandanaid, a.bandanacontext, a.bandanakey, a.bandanavalue
      		FROM bandana a
      ) 
    LOOP 
      
      BEGIN 
      	EXECUTE IMMEDIATE 'INSERT INTO bandana_tmp VALUES (a.bandanaid, a.bandanacontext, a.bandanakey, a.bandanavalue)';
      EXCEPTION 
      	WHEN OTHERS THEN dbms_output.put_line(SQLERRM||'-'||a.Rownum);
      END;
      
    END LOOP;
      
    ALTER TABLE bandana RENAME TO bandana_corrupt;
      
    EXECUTE IMMEDIATE 'ALTER TABLE bandana_tmp RENAME TO bandana';
  
END;