BEGIN
    FOR rec IN (SELECT TABLE_NAME, owner
        FROM all_tables
        WHERE owner = '模式名' and TABLE_NAME not in ('SYS_MENU', 'SYS_CONFIG', 'DOCK')) LOOP
        EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || rec.TABLE_NAME;
    END LOOP;
END;

把指定【模式名】下的所有的表都执行 truncate table 表名;