Cacher is the code snippet organizer for pro developers

BEGIN
    FOR reg IN (SELECT table_name
                FROM   user_tables)
    LOOP
        BEGIN
            EXECUTE IMMEDIATE 'ALTER TABLE ' || reg.table_name || ' DISABLE ALL TRIGGERS';
        EXCEPTION
            WHEN OTHERS THEN
                dbms_output.put_line('Error disabling triggers of table ' || reg.table_name);
        END;
    END LOOP;
END;
/