Re: User-Controlled DBMS_DataPump Backups and Restores

From: stephen van linge <>
Date: Tue, 10 Feb 2015 05:41:30 +0000
Message-ID: <>

GitHub would be great.  After a lot of replace-all'ing (double quotes to double single quotes, characters that didn't exist in PL/SQL developer, etc), I was able to make it work.  I think most others would prefer a plug and play version though.  Some more documentation or an example or two of each function would help too (also mentioning the directory that needs to be created, that one took me a little while to figure out with the awful error message "invalid parameters" or something of the sort). So far it works great though, thanks for putting this together! Stephen
  From: Phil Jones <>  To:
Cc: "" <>; "" <>  Sent: Monday, February 9, 2015 2:42 PM
 Subject: Re: User-Controlled DBMS_DataPump Backups and Restores    

It'd be best on GitHub. Easy to update to new versions etc. Cheers,

On 9 Feb 2015, at 21:41, stephen van linge (Redacted sender "" for DMARC) <> wrote:

Do you think you could make a downloadable package file for this?  I'm having to do a lot of replace alls to remove formatting from the html copy+paste... I can see a lot of uses with this in our dev environment provided we can get space allocated from sa and get the developers to consolidate their data source names (might be asking a lot with the latter)... Thanks, Stephen   From: Jack Applewhite <>  To: "" <>  Sent: Monday, February 9, 2015 9:34 AM
 Subject: User-Controlled DBMS_DataPump Backups and Restores    

I've posted a PL/SQL package for User-controlled backups and restores of their schemas using DBMS_DataPump and thought others might be interested. I couldn't find anything on the Web that did what I wanted and was easy for a User to execute, so I rolled my own - with a starting point of the DataPump API examples in the Utilities doc. We're on 11gR2, Oracle Linux on ODAs.

Below is the link. Check it out and let me know where it can be improved. Also how my WordPress layout could be better. This is my first attempt at it.


Jack C. Applewhite - Database Administrator Austin I.S.D. - MIS Department
512.414.9250 (wk)
Confidentiality Notice: This email message, including all attachments, is for the sole use of the intended recipient(s) and may contain confidential student and/or employee information. Unauthorized use of disclosure is prohibited under the federal Family Educational Rights & Privacy Act (20 U.S.C. §1232g, 34 CFR Part 99, 19 TAC 247.2, Gov’t Code 552.023, Educ. Code 21.355, 29 CFR 1630.14(b)(c)). If you are not the intended recipient, you may not use, disclose, copy or disseminate this information. Please call the sender immediately or reply by email and destroy all copies of the original message, including attachments.       

-- Received on Tue Feb 10 2015 - 06:41:30 CET

Original text of this message