DBMS_DATAPUMP exposes all the functionality available via the impdp and expdp commands available from a command prompt. Most of the time, access is limited to these commands, because they are owned by the 'oracle' user. However, this functionality can be exposed, to users and external programs without forcing them into command-line tools. Use Case Developers are requesting schema refreshes from production all the time and complaining that they aren't fast enough. It's also a time sink, even for the most junior DBA. This is a case for automation, but how? Prerequistes Create a schema specific for containing objects necessary for these types of self-service operations. I like 'MYDBA' (Q: Can you do this? A:Why don't you ask MYDBA.) or can you give this schema a character name, like Orko .(exec ORKO.REFRESH_SCHEMA()) Additionally, a database link is created from the refresh target, to the source. Ideally, this will be a private database link. In my...