-- NOTE: do NOT clear table UIDGEN.  Doing so could produce duplicate
-- IDs which are visible to external program.

begin
  for trec in (select table_name from user_tables where table_name <> 'UIDGEN' and table_name NOT LIKE 'BIN%') loop
    execute immediate 'drop table '||trec.table_name||' cascade constraint';
  end loop;
end;
/

DROP SEQUENCE pramhist_seq;
-- For Oracle 10 and above, dropped tables take space until the
-- recycle bin is purged.  This command will fail on Oracle 9.

purge recyclebin;

quit;
