begin
 for x in (select table_name from user_tables where table_name like 'CHI_%')
 loop
   execute immediate 'drop table ' || x.table_name || ' purge';
 end loop ;
end;
/