How to drop all user tables?

Question

How can I drop all user tables in oracle?

I have problem with constraints. When I disable all it is still no possible.

Answer 1

The simplest way is to drop the user that owns the objects with the cascade command.

DROP USER username CASCADE

Answer 2

The easiest way would be to drop the tablespace then build the tablespace back up. But I'd rather not have to do that. This is similar to Henry's except that I just do a copy/paste on the resultset in my gui.

SELECT
  'DROP'
  ,object_type
  ,object_name
  ,CASE(object_type)
     WHEN 'TABLE' THEN 'CASCADE CONSTRAINTS;'
     ELSE ';'
   END
 FROM user_objects
 WHERE
   object_type IN ('TABLE','VIEW','PACKAGE','PROCEDURE','FUNCTION','SEQUENCE')