BEGIN
  FOR cur_rec IN (
    SELECT     object_name, object_type
    FROM     user_objects
    WHERE     object_type IN ('TABLE','VIEW','MATERIALIZED VIEW','PACKAGE','PROCEDURE','FUNCTION','SEQUENCE','SYNONYM')
  )

LOOP
  BEGIN
  IF cur_rec.object_type = 'TABLE'
    THEN EXECUTE IMMEDIATE 'DROP ' || cur_rec.object_type || ' "' || cur_rec.object_name || '" CASCADE CONSTRAINTS';
    ELSE EXECUTE IMMEDIATE 'DROP ' || cur_rec.object_type || ' "' || cur_rec.object_name || '"';
    END IF;

  EXCEPTION
  WHEN OTHERS
    THEN DBMS_OUTPUT.put_line ('FAILED: DROP ' || cur_rec.object_type || ' "' || cur_rec.object_name || '"');
  END;
END LOOP;
END;
/