clear temp table.sql

-- Clear all temp tables in your space

undef current_schema;
begin 
  for cur_cleanup in (
                              select object_name
                                        ,object_type 
                              from  user_objects 
                              where object_type = 'TABLE'
                               and temporary = 'Y'
                            )
    loop 
      begin 
      execute immediate 'truncate '|| cur_cleanup.object_type|| ' "'|| 
      cur_cleanup.object_name|| '" drop storage'; 
      execute immediate 'drop '|| cur_cleanup.object_type|| ' "'|| 
      cur_cleanup.object_name|| '" cascade constraints'; 
      end; 
end loop; 
end;