Re: User-Controlled DBMS_DataPump Backups and Restores

From: stephen van linge <>
Date: Mon, 09 Feb 2015 21:41:12 +0000
Message-ID: <>

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    

#yiv9545260288 #yiv9545260288 -- p {margin-top:0px;margin-bottom:0px;}#yiv9545260288 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 Mon Feb 09 2015 - 22:41:12 CET

Original text of this message