INSERT INTO t1 SELECT * FROM t2

PROCEDURE RUN_GENERIC(p_TableName IN VARCHAR2, p_CommitCount IN NUMBER) IS

    genericCursor SYS_REFCURSOR;

    TYPE GENERIC_ROW IS TABLE OF genericCursor%ROWTYPE;

    genericRow GENERIC_ROW;

BEGIN

    EXECUTE IMMEDIATE('TRUNCATE TABLE t_' || p_TableName);

    OPEN genericCursor FOR 'SELECT * FROM v_' || p_TableName;

    LOOP

        FETCH genericCursor BULK COLLECT INTO genericRow LIMIT p_CommitCount;

        FORALL i IN genericRow.FIRST..genericRow.LAST SAVE EXCEPTIONS
            EXECUTE IMMEDIATE('INSERT INTO t_' || p_TableName || ' VALUES(:1)') USING genericRow(i);

        COMMIT;

    END LOOP;

    CLOSE genericCursor;

END RUN_GENERIC;