IDS drop all sequences and tables

drop_tables.sql

-- source: http://stackoverflow.com/questions/2549718/dropping-all-user-tables-sequences-in-oracle
DECLARE
  login varchar2(8);
BEGIN
  -- Change value according to your username
  login := 'XLUCAN01';

  -- Remove all sequences
  FOR i IN (SELECT us.sequence_name, us.sequence_owner
              FROM ALL_SEQUENCES us WHERE sequence_owner = LOGIN) LOOP
    EXECUTE IMMEDIATE 'drop sequence '|| i.sequence_name ||'';
  END LOOP;

  -- Remove all tables
  FOR i IN (SELECT ut.table_name
              FROM ALL_TABLES ut WHERE owner = LOGIN) LOOP
    EXECUTE IMMEDIATE 'drop table '|| i.table_name ||' CASCADE CONSTRAINTS ';
  END LOOP;

END;
/