How do I drop all tables in Oracle Schema?

[albertcooley08712]

How do I drop all tables in Oracle Schema?

[GordonFry43]

The quickest way tp drop all objects within a schema is to drop the schema and recreate it afterwards.
If you only want to drop all the tables create a drop script from the data dictionary and run it.
Views, procedures, functions, and all other inter-schema references will all become invalid.

[Inmorr]

The fastest way to interact with objects in an Oracle schema is to use the right tool for the job. For example, I use for oracle analyze table and oracle schema compare script , this tool and am completely satisfied with how it works. Since this comprehensive tool has become indispensable for me, it also helps in identifying all the differences between databases.