Sometimes you have to export all metadata for a schema but you have no access to data pump or other tools. SQL Developer can cause a lot of problems with referential constraints. But there is always a good old SQL*Plus 🙂
http://ora-600.pl/oinstall/metadata.sql
Code listings
No code listings in this article.