I need to export all user objects ddl while having minimal rights on the schema. I cannot use dbms_metadata.get_ddl.
This needs to be automated. I prefer to use code. I know sqldeveloper and toad, etc can export via GUI, so a command line solution would work too.
Does anyone know an efficient way to do this?
2nd question, how to Google this issue, I'm going nuts trying to weed through lots of hits.
Windows 7 64bit