oracle删除表空间下所有内容

declare

    v_name all_tables.table_name%type;

    cursor mycur is select table_name from all_tables where owner='TEST';

begin

    open mycur;

    loop

        fetch mycur into v_name;

        exit when mycur%NOTFOUND OR mycur%NOTFOUND IS NULL;

        execute immediate 'drop table '|| v_name;

    end loop;

    close mycur;

end;