User-Controlled DBMS_DataPump Backups and Restores

From: Jack Applewhite <jack.applewhite_at_austinisd.org>
Date: Mon, 9 Feb 2015 17:34:09 +0000
Message-ID: <1423503248484.79731_at_austinisd.org>



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.

https://jackapplewhite.wordpress.com/

Thanks.



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.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Feb 09 2015 - 18:34:09 CET

Original text of this message