How to get a complete schema dump of an Oracle database?
Posted on 2014-11-03
I'm trying to export the schemas (Tables, Procedures, Packages, etc.) I have access to, into a .sql file.
I'm not the root user/or the person who owns the schemas, but I'd like to copy all the schemas I have access to; so that I can recreate the database in another location.
Is there a simple way to do this? Or do I need to go log in as each schema's ID and export the objects under that ID?
Appreciate any help on this!